Re: [GENERAL] Executing a user created function twice give an error

2008-12-05 Thread Wajid Khattak
Thanks for all of you help. It's working now :-) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Executing a user created function twice give an error

2008-12-04 Thread Wajid Khattak
- Original Message - From: "A. Kretschmer" <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: 02 December 2008 12:50:44 o'clock (GMT) Europe/London Subject: Re: [GENERAL] Executing a user created function twice give an error am Tue, dem 02.12.2008

Re: [GENERAL] Executing a user created function twice give an error

2008-12-02 Thread Wajid Khattak
:20 o'clock (GMT) Europe/London Subject: Re: [GENERAL] Executing a user created function twice give an error am Tue, dem 02.12.2008, um 11:11:44 + mailte Wajid Khattak folgendes: > Hi, > > PostgreSQL 8.1.11 > > I have created a function that works fine when run for the first

[GENERAL] Executing a user created function twice give an error

2008-12-02 Thread Wajid Khattak
Hi, PostgreSQL 8.1.11 I have created a function that works fine when run for the first time after that it gives an error until I open another Query window. The function is as follows /// CREATE OR REPLACE FUNCTION func_snappointtonetwork(p_pointtobesnapped "varcha