Allowing SYSDATE to Work

Поиск
Список
Период
Сортировка
От Matt Miller
Тема Allowing SYSDATE to Work
Дата
Msg-id 1163802397.5464.276316451@webmail.messagingengine.com
обсуждение исходный текст
Ответы Re: Allowing SYSDATE to Work
Re: Allowing SYSDATE to Work
Список pgsql-general
I'd like SYSDATE to work syntactically and semantically the same as
CURRENT_TIMESTAMP (or CURRENT_TIME, or whatever).  I can create a
function called "sysdate" that does the trick, but then it seems I have
to reference the function as "sysdate ()," but I want to be able to get
away with just "sysdate."  It seems that CURRENT_TIMESTAMP and their
friends are magic functions that can be referenced without an explicit
empty argument list.

I have much Oracle-specific code that references sysdate, and porting
would be easier if that syntax could work unchanged in Postgres.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: can't delete because of constraint from zombie table
Следующее
От: Bob Pawley
Дата:
Сообщение: After Update Triggers