Re: Problem with LIKE in a SQL function

From: Mole <mole(at)zebra(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with LIKE in a SQL function
Date: 2002-11-01 16:36:56
Message-ID: E187elc-0000j8-00@zebrahosts.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

many thanks to Garret and Tom, that did the trick.

"SELECT mailbox FROM user WHERE mailbox LIKE (SELECT ($1 || \'%\')); "

Mole
--
==============
Caroline Fletcher
Head of Systems
Zebrahosts

Browse pgsql-novice by date

  From Date Subject
Next Message Jochen Kächelin 2002-11-01 17:28:36 Startup-Script
Previous Message Garrett Bladow 2002-11-01 16:12:03 Re: Problem with LIKE in a SQL function