Skip site navigation (1) Skip section navigation (2)

Re: create function question

From: "Zhou, Lixin" <LZhou(at)illumina(dot)com>
To: "'Stephan Szabo'" <sszabo(at)megazone23(dot)bigpanda(dot)com>, "Zhou, Lixin" <LZhou(at)illumina(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: create function question
Date: 2001-10-30 20:34:43
Message-ID: 6EDF654BC7BFE648AB2E734727E7078D0737DB@illumina24.illumina.com (view raw or flat)
Thread:
Lists: pgsql-general
I followed up the original post, and I don't know if the follow-up has been
posted or not.

The trick is: do not use quotes ('') for variables declared in the declare
secton.

Thanks.

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone23(dot)bigpanda(dot)com]
Sent: Tuesday, October 30, 2001 12:32 PM
To: Zhou, Lixin
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] create function question



On Mon, 29 Oct 2001, Zhou, Lixin wrote:

> The following function always returns NULL when I call it like this:
>
> select get_bundle_id('1009699', '1', '1').
>
> If I replace b, r, c with '1009699', '1', '1' inside the function body, it
> returns the correct id!

Probably you shouldn't double quote the b r and c in the function since
that'd be the constants not the variables.

pgsql-general by date

Next:From: Antonio Sergio de Mello e SouzaDate: 2001-10-30 22:03:14
Subject: Re: pgadmin2
Previous:From: Stephan SzaboDate: 2001-10-30 20:32:22
Subject: Re: create function question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group