performance.
Regards,
R.Muralidharan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 5:45 PM
To: CHRIS HOOVER
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Record Log Trigger
Well...
Right, I will use to_timestamp
k time:
to_char(to_timestamp(timeofday(),\'Dy Mon DD HH24:MI:SS.US \')
HTH,
Chris
--( Forwarded letter 1 follows )-
Date: Mon, 02 May 2005 16:10:46 -0300
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Subject: [SQL] Record Log Trig
ject: [SQL] Record Log Trigger
Hi all,
I am building a database in postgresql and I made a function that returns the
system time and the current user... like this:
CREATE OR REPLACE FUNCTION generate_idx() returns text as
$$
select to_char(now(),'MMDDHHMISSUSTZ')||CURRENT_USE
Hi all,
I am building a database in postgresql and I made a function that returns the
system time and the current user... like this:
CREATE OR REPLACE FUNCTION generate_idx() returns text as
$$
select to_char(now(),'MMDDHHMISSUSTZ')||CURRENT_USER;
$$ language 'SQL';
CREATE OR REPLACE FUNC
