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

• Re: Function proposal to find the type of a datum at 2007-02-02 07:17:51 from Tom Lane

pgsql-hackers by date

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