That works. Thanks! (Thanks also to Joshua Drake, who contributed the same answer.)
~ Ken > -----Original Message----- > From: Michael Glaesemann [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 30, 2005 11:19 PM > To: Ken Winter > Cc: PostgreSQL pg-general List > Subject: Re: How to run a stored PL/pgSQL function? > > > On Dec 1, 2005, at 12:38 , Ken Winter wrote: > > > How can I cause a PL/pgSQL function to be executed from a SQL script? > <snip /> > > I have a PL/pgSQL "foo (varchar)". > select foo(bar); -- where bar is of type varchar > > > Michael Glaesemann > grzm myrealbox com > > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match