Re: text cast on regprocedure fails on 8.2

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: text cast on regprocedure fails on 8.2
Date: 2009-08-21 08:09:36
Message-ID: 20090821080936.318530@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Alvaro, Hello Tom,

thank you very much for your quick and helpful replies.

> You can always cast pretty much anything to anything via a variable
> assignment in plpgsql...

<thud> I only tried it in SQL. So the function works just fine after the removal of the text cast on 8.2 as well.

For SQL I'll stick with "textin(regprocedureout(p.oid::regprocedure))".

Peter

--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message PESTY Benoit 2009-08-21 09:33:59 Background color in query tool
Previous Message Melvin Davidson 2009-08-21 02:13:35 Feature / Enhancement request.