Re: Function proposal to find the type of a datum

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: kate(at)cats(dot)meow(dot)at
Subject: Re: Function proposal to find the type of a datum
Date: 2007-02-02 06:49:18
Message-ID: BAY114-F24EB8FCA34F4BC482871B9F99B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

you can identify type via operator OF.

like:

IF a IS OF INTEGER THEN
RAISE NOTICE 'Parametr a is numeric';
ELSIF a IS OF varchar THEN
RAISE NOTICE 'Parametr a is string';
END IF;

Regards
Pavel Stehule

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2007-02-02 06:55:18 Re: writing new regexp functions
Previous Message Jeremy Drake 2007-02-02 06:16:54 Re: writing new regexp functions