Re: [SQL] Few Queries

From: "Richard Huxton" <[EMAIL PROTECTED]> To: "Sugandha Shah" <[EMAIL PROTECTED]>; "Janning Vygen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 7:04 PM Subject: Re: [SQL] Few Queries On Wednesday 14 Aug 2002 1:29 pm, S

Re: [SQL] Few Queries

et_time;END IF;       return true; END;'LANGUAGE 'plpgsql';   Regards, -Sugandha     - Original Message - From: "Janning Vygen" <[EMAIL PROTECTED]> To: "Sugandha Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, Au

[SQL] parser: parse error at or near "$1"

Hi , I'm getting this  error :   Error occurred while executing PL/pgSQL function ins_schedule_status line 42 at SQL statementparser: parse error at or near "$1"   Unable to locate the cause. Please any hint or clue will be of great help.   Below is the function     CREATE FUNCTION ins_sched

[SQL] Few Queries

  Hi ,     I'm still facing few problems and hence the query . I have searched the archives as well as read the manual.   1. I 'm firing a query and it returns the value in variable which I need to pass to other query .  Is this a right way to pass the value ? I'm newbie to     this Databas

Re: [SQL] Function error

Hi , Thanx a lot it worked . Is there any equivalent of dateadd function in postgres ? Regards, -Sugandha - Original Message - From: "Janning Vygen" <[EMAIL PROTECTED]> To: "Sugandha Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday

[SQL] Function error

Hi ,   I'm porting MS- SQL stored procedure to postgres . I'm getting this error :   Error occurred while executing PL/pgSQL function sel_free_disk_space line 7 at SQL statementSELECT query has no destination for result data.If you want to discard the results, use PERFORM instead. Here is th