X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D288256454
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Mar 2005 08:58:16 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 18297-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Mar 2005 08:58:08 +0000 (GMT)
Received: from ns1.intersan.com.tr.intersan.com.tr (unknown [213.204.65.190])
	by svr1.postgresql.org (Postfix) with ESMTP id 066C3563A1
	for <pgsql-sql@postgresql.org>; Wed,  9 Mar 2005 08:58:06 +0000 (GMT)
Received: from cerit (unknown [213.204.65.187])
	by ns1.intersan.com.tr.intersan.com.tr (Postfix) with ESMTP id
	7152F404A2
	for <pgsql-sql@postgresql.org>; Wed,  9 Mar 2005 11:01:47 +0200 (EET)
Message-ID: <008a01c52486$1c1c9520$bb41ccd5@cerit>
From: "Fatih Cerit" <fatih@intersan.com.tr>
To: <pgsql-sql@postgresql.org>
Subject: interval +variable
Date: Wed, 9 Mar 2005 10:58:05 +0200
Organization: intersan ltd.
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-9";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.095 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200503/140
X-Sequence-Number: 20619

Dear all

Is there anyone at there who knows howto use dateadd in pgsql. I have a 
problem in my function that is like this ;

Select into futuredate now() + interval '30 days';  <- this is ok
but how can I use a variable intead of '30 days'    :(

Thanks