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

Поиск
Список
Период
Сортировка
От litu16
Тема Re: INSERT a real number in a column based on other columns OLD INSERTs
Дата
Msg-id 1435205188470-5855071.post@n5.nabble.com
обсуждение исходный текст
Ответ на INSERT a real number in a column based on other columns OLD INSERTs  (litu16 <litumelendez@gmail.com>)
Ответы Re: Re: INSERT a real number in a column based on other columns OLD INSERTs  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Correct place for feature requests
Следующее
От: litu16
Дата:
Сообщение: Get the difference between two timestamp cells but in a special format in PostgreSQL