Helo Madam,
Here is the query.
select now()+ interval '-1 day '
Regards,
ram
- Original Message -
From: Shruthi A
To: pgsql-sql@postgresql.org
Sent: Wednesday, October 14, 2009 3:10 PM
Subject: [SQL] How to get the previous date?
Hi,
I'm using Enterprise DB Postgre
Yes you can make a procedure call in a trigger function.
Example
Trigger block
{
PERFORM Procedure();
}
Regards.
Ram
- Original Message -
From: "Scott Marlowe"
To: "Doug Pisarek"
Cc:
Sent: Thursday, August 20, 2009 9:31 AM
Subject: Re: [SQL] Call Procedure From Trigger Function
Hi,
Can you just tell me whether your database is place on which
server(linux/or windows or..)?
- Original Message -
From: Jan Verheyden
To: 'pgsql-sql@postgresql.org'
Sent: Tuesday, August 11, 2009 6:31 PM
Subject: [SQL] mail alert
Hi All,
I was looking in wha
Dear Bor,
How you will 1 record for 2009/05 (if you use 2009/05 ) it will fetch
all the records as it is not having month 05
am i correct?
- Original Message -
From: "Bor"
To:
Sent: Tuesday, August 11, 2009 6:43 PM
Subject: [SQL] Month/year between two dates
Hi to all,
I hav
HI all,
I am facing a problem while taking a back up in windows. It is asking for a
password while using pg_dump. Why it is asking for a password ?(it is not
asking password in linux)
Give some details about fe_sendauth in postgres .
How i can avoid asking password in windows shile taking bac
Hi ,
The query is like this ,
Except
SELECT * from ((SELECT COUNT(id) FROM table1) Except (SELECT COUNT(id)
FROM table2))tmp
Regards,
Ram
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Craig Ringer
Sent: Thursday, May 22, 2008 9:05 PM
To: Nacef LA
HI Sumaya,
This is the way you have to use dblink. And one more think.
To excute this query you nedd to have dblink functions installed in your
database schema.
select * from dblink('YOUR_DB_LINK_NAME','select * from mytable')as
tmp(column1 datatype,column2 datatype.)
Regards,
R
