Re: INSERT a real number in a column based on other columns OLD INSERTs

From: litu16 <litumelendez(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT a real number in a column based on other columns OLD INSERTs
Date: 2015-06-25 04:06:28
Message-ID: 1435205188470-5855071.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message litu16 2015-06-25 04:11:24 Get the difference between two timestamp cells but in a special format in PostgreSQL
Previous Message David G. Johnston 2015-06-24 22:31:12 Re: INSERT a real number in a column based on other columns OLD INSERTs