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

sqlite3 - UPDATE a table from the SELECT of another one -

I have the first table article where some data is missing. In the table, articles_tmp I have a part of the missing data. So I want to update the articles. Where the path path is data in articles_tmp.path where the path is not zero . With SQLite , it does not work: update article SET path = (SELECT at.path FROM Articles_tmp as AS, WHERE at.article_id = a.id and a.asp, the text is in the form and not on. It has been transmitted) where the path is null MS Access Along with, it works fine: Update Articles Join the Inner Articles at articles_tmp articles.id = articles_tmp.id SETP articles.path = articles_tmp.path Can anyone help? Sin CE SQL Server Syntax, which I provided, was not working, here this solution With whom I have come. A little modification of your original query, but with my "correlation" suggestion added. There is a SQL Bella for this: Here is the code: update article SET path = (SELECT path from articles_tmp AS T WHERE t.id
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

javascript - Render HTML after each iteration in loop -

I'm trying to gradually increase the font size of text on a web page. The code works in my place, although the new HTML / CSS does not render after every iteration of the loop and when all this is done, then display only the text of 100 px size. To see the text as if it is slowly zooming, I need to do this JavaScript is down because it is being used from a different file here is what I have ... < Pre> & lt; P class = "game-title" style = "font-size: 50px" & gt; Test & lt; / P & gt; Function sleep (milliseconds) {var start = new date (). GetTime (); For (var i = 0; i & lt; 1e7; i ++) {if ((new date). GetTime () - start) & gt; Milliseconds {break; CSS ('font-size', 'parseInt ($ (' game-title '). CSS (' font-size ')) + 1 + "pixels"); } While (parasont ($ ('# text'). Css ('font-size')) & lt; = 100) {sleep (1000); IncreaseSize (); Using CSS: Use of jQuery (sample):
Read more