Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT a real number in a column based on other columns OLD INSERTs - Mailing list pgsql-general

From litu16
Subject Re: INSERT a real number in a column based on other columns OLD INSERTs
Date
Msg-id 1435205188470-5855071.post@n5.nabble.com
Whole thread Raw
In response to INSERT a real number in a column based on other columns OLD INSERTs  (litu16 <litumelendez@gmail.com>)
Responses Re: Re: INSERT a real number in a column based on other columns OLD INSERTs  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view 
Thanks to everybody
I already solved,
the correct syntax was...
SELECT t.time_index FROM table_ebscb_spa_log04 t WHERE t.fn_name =
NEW.fn_name AND (t.time_type = 'Start' OR time_type = 'Lap') ORDER BY
t.stmtserial DESC LIMIT 1 INTO t_ix;

Thanks for all again.



--
View this message in context:
http://postgresql.nabble.com/INSERT-a-real-number-in-a-column-based-on-other-columns-OLD-INSERTs-tp5854916p5855071.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Correct place for feature requests
Next
From: litu16
Date:
Subject: Get the difference between two timestamp cells but in a special format in PostgreSQL