Skip site navigation (1) Skip section navigation (2)

Re: POSTGRESQL and PERL?

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Peter Landis <ntwebdeveloper(at)yahoo(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: POSTGRESQL and PERL?
Date: 2000-05-26 16:35:35
Message-ID: 392EA7D7.BD13724E@austin.rr.com (view raw or flat)
Thread:
Lists: pgsql-sql
Peter Landis wrote:
> 
> but what if you have a variable set like:
> $sort_selection = "name";
> 
> How do you sort by the variable?
> 
> For instance you cannot do...
> $sqh = $dbh->prepare(q{select name from company order
> by $sort_selection;});

Why not?  The query string is created before prepare is called...

Regards,
Ed Loehr

In response to

Responses

pgsql-sql by date

Next:From: Richard HuxtonDate: 2000-05-26 17:41:33
Subject: Re: POSTGRESQL and PERL?
Previous:From: Tom LaneDate: 2000-05-26 16:26:06
Subject: Re: aliases break my query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group