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

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 (view raw or flat)
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

pgsql-hackers by date

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

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