Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [ADMIN] Function's final statement must be a SELECT
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Premil Agarwal <preagarw(at)gmail(dot)com>
- Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [ADMIN] Function's final statement must be a SELECT
- Date: Wed, 14 May 2008 16:36:21 -0400
- Message-id: <20080514203621(dot)GI9838(at)alvh(dot)no-ip(dot)org>
Premil Agarwal escribió:
> I am trying to write a function in PgAdmin 1.8.2 for postgres 8.3. The
> function should check the input parameter for NULL. If its NULL then
> function should return 'Auto' otherwise return the input as such.
>
> CREATE FUNCTION check_for_null( inp character varying) RETURNS character
> varying AS $$
[...]
> $$ LANGUAGE SQL;
^^^
There's your problem. Try using PLPGSQL instead.
In any case, you can do this with COALESCE() and it's much easier.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
- Follow-Ups:
- Re: [ADMIN] Function's final statement must be a SELECT
- From: Premil Agarwal
- Re: [ADMIN] Function's final statement must be a SELECT
- References:
- Function's final statement must be a SELECT
- From: Premil Agarwal
- Function's final statement must be a SELECT
- Prev by Date: Re: Function's final statement must be a SELECT
- Next by Date: Re: Function's final statement must be a SELECT
- Previous by thread: Re: Function's final statement must be a SELECT
- Next by thread: Re: [ADMIN] Function's final statement must be a SELECT
- Indexes: