From: landsharkdaddy <ldodd@landsharksoftware.com>
To: pgsql-sql@postgresql.org
Subject: Re: Query with Parameters and Wildcards
Date: Sun, 26 Apr 2009 22:01:14 -0700 (PDT)
Message-ID: <23250153.post@talk.nabble.com> (raw)
In-Reply-To: <dcc563d10904262154n19dd9f77pe81fe23eebeeac2e@mail.gmail.com>
References: <23248274.post@talk.nabble.com>
<dcc563d10904262154n19dd9f77pe81fe23eebeeac2e@mail.gmail.com>
I have not tried that but I will in the morning. The @ in SQL is used to
indicate a parameter passed to the query. In PostgreSQL it seems that the :
is the same as the @ in SQL Server. I tried something like:
SELECT * FROM Customers WHERE FirstName LIKE :custfirst + '%';
And it told me that the + could not be used. Not sure the exact message but
I will check again tomorrow and see what it was and post the results.
Scott Marlowe-2 wrote:
>
> On Sun, Apr 26, 2009 at 6:21 PM, landsharkdaddy
> <ldodd@landsharksoftware.com> wrote:
>>
>> I have a query that works on SQL Server to return customers that contain
>> the
>> string entered by the user by accepting parameters and using the LIKE
>> keyword. I would like to move this to postgreSQL but I'm just not sure
>> how
>> to get it done. This is the query
>>
>> SELECT * FROM Customers WHERE FirstName LIKE @custfirst + '%';
>>
>> This works great on SQL Server but not on postgreSQL. Any help would be
>> appreciated.
>
> Have you tried:
>
> SELECT * FROM Customers WHERE FirstName LIKE 'custfirst%';
>
> What does the @ do in sql server?
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
>
--
View this message in context: http://www.nabble.com/Query-with-Parameters-and-Wildcards-tp23248274p23250153.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ldodd@landsharksoftware.com
Subject: Re: Query with Parameters and Wildcards
In-Reply-To: <23250153.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox