PostgreSQL add id column that increments based on data -


I am relatively new to using postgrades coming from a MySQL background. I am using PostGrace 9.3.4 on Windows X64.

Data is being supplied to us in several definite length text files The first digit on each line is a number between 1 and 4, which indicates the record type of the data in that row, respectively Are grouped in form, because there will always be a first row and after this there will be other types of zeros or more rows. 

  data_x.txt --------- ------------ 1data01 2data02 4data03 4data04 1data05 1data06 3data07
< P> I used the following SQL commands to import it into Postgrass: 

  Create table datadown (raw_data TEXT); Cpp data_word from 'c: \ path \ data_x.txt' ... ...; - Repeated optional table data_raw column indicator indicator for each file; UPDATE data_raw SET indicator = CAST (substr (raw_data, 1, 1) AS integer), raw_data = substr (raw_data, 2);

I create tables for each of the 4 record types: 

  Create table table 1 Select raw_data from data_off WHERE indicator = 1; Select table table 2 raw_data FROM data_raw where pointer = 2; Create table table - select raw_data related to data WHERE indicator = 3; Create table table - select raw_data from data_by WHERE indicator = 4;

What I have to do, but uncertain how to add an "id" column to each group, where the indicator starts from 1. We will be getting weekly updates so that I need to specify the initial ID for each batch, so if this batch starts at id = 225, then I want to get the following table from sample data:

< Pre> table_1 id | Raw_data -------------------- 225 | Data 016 226 | Data05 227 | Data06 table_2 ID Raw_data -------------------- 225 | Data02 table_3 ID | Raw_data -------------------- 227 | Data07 table_4 ID | Raw_data -------------------- 225 | Data 03 225 | Data 04

Try something like this to generate an ID for each data set: < / P> Data_w

as 

  SELECT sum (when indicator = 1 then 1 and 0 end) over (order / some To define the order * /) will generate a  id_base  for each data group if you need to start with a particular ID - just add this ID to  id_base  .

-

Comments

Post a Comment

Popular posts from this blog

Member with no value in F# -

After I am trying to convert F # to the following C # code: [StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi)] Private class DOCINFOA {[MarshalAs (UnmanagedType.LPStr)] public string nomeDocumento; [Marshall (UnmanagedType.LPStr)] Public string arquivoSaida; [Marshall (UnmanagedType.LPStr)] Public String Tipodo; } I am doing the following: Named place printer module RawPrinterHelper = [& LT; StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi) & gt;] Type DOCINFOA = [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member this.nomeDocumento [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member this.arquivoSaida [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member This Tipoda [/ code> But I get: One type of definition is necessary for one or more members . Can I vacate these members? you val code> member : [& lt; StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi) & gt;] Type DOCINFOA = [...
Read more

java - Joda Time Interval Not returning what I expect -

मेरे पास निम्न प्रोग्राम है import java.util। *; Import java.text। *; आयात करें org.joda.time। *; सार्वजनिक श्रेणी के स्कोप कंट्रोल {सार्वजनिक स्थिर अंतराल मिलनसार () {दिनांक समय currDate = नया दिनांक समय (2008, 4, 4, 15, 30, 0, 0); दिनांक समय epochDate = नया दिनांकटाइम (2000, 1, 1, 12, 0, 0, 0); अंतराल अंतराल = नया अंतराल (युरोप डेट, करोडेट); वापसी अंतराल; } सार्वजनिक स्थिर शून्य मुख्य (स्ट्रिंग [] आर्ग्स) {डबल दिनबात = मिलते समय ()। ToDurationMillis () / 1000/60/60/24; StdOut.println (daysBtween); }} मुझे आउटपुट मिल रहा है: 3016.0 लेकिन जो मैं देख रहा हूं वह है: 3016.1458333333 मैं क्या कर रहा हूँ ? toDurationMillis एक लंबा लौटा देता है, और प्रत्येक प्रभाग को int के रूप में घोषित किया जाता है। जावा इस प्रकार इनट्स को लॉन्ग में परिवर्तित कर देगा और डिवीजन को लंबे समय तक लौटाना होगा। परिणाम को अंत में दोहरे रूप में परिवर्तित करना। डबल्स का उपयोग करके अभिव्यक्ति करने के लिए जावा को बताने के लिए, अभिव्यक्ति के किसी भी घटक को दोहरे रूप में घोषित करें। उदाहरण के लिए: ...
Read more

c# - Showing a SelectedItem's Property -

So I have enabled a rightclick option for my DataGrid. I want to display the only chosen property but it is not behaving like what I would like it to display my name and additional. Public category Paymentinfo {public int PaymentNo {get; Set; } Public string date {get; Set; } Public Double Pay {get; Set; } Public Double Principle {get; Set; } Public Double Interest {get; Set; } Public Double Balance {Received; Set; }} Private Zero MenuItem_OnClick (Object Sender, RoutedEventArgs e) {MessageBox.Show (AmortGrid.SelectedItem.ToString ()); } I'm trying to apply it without using a View Module! If I place a breakpoint where the messagebox and the recipient place it on selected ITEM, then this property will display the payment. A date-payment-principle-interest-balance is the only value that needs payment. Was hoping that it would be something like this MessageBox.Show (AmortGrid.SelectedItem.PaymentNo.ToString ()); When you call ToString () So you get the class typ...
Read more