using ILIKE xyz where xyz is a function parameter

#1

Hi,

I'm stuck here.

I have a function that I would like to pass a text string and have the
function perform ILIKE on that passed string.

create or replace function foo( sLastName text )
AS

Select * from Person where LastName ILIKE sLastName;
....

What is the syntax for using ILIKE '%sLastName%' ??

Thanks for any tips,

Frank

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

using ILIKE xyz where xyz is a function parameter

comp.databases.postgresql.general comp.databases.postgresql.general

using ILIKE xyz where xyz is a function parameter - 07-10-2007 , 05:49 PM