From: Steve Crawford <scrawford@pinpointresearch.com>
To: Rehan Saleem <pk_rehan@yahoo.com>
Cc: sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: how to concatenate in PostgreSQL
Date: Tue, 27 Mar 2012 09:12:47 -0700
Message-ID: <4F71E6FF.6060204@pinpointresearch.com> (raw)
In-Reply-To: <1332859717.73799.YahooMailNeo@web121606.mail.ne1.yahoo.com>
References: <1332589439.54415.YahooMailNeo@web121601.mail.ne1.yahoo.com>
<4F709481.30503@pinpointresearch.com>
<1332859717.73799.YahooMailNeo@web121606.mail.ne1.yahoo.com>
On 03/27/2012 07:48 AM, Rehan Saleem wrote:
> well i am quite sure its PostgreSQL forum and it is obvious, i am
> asking this to concatenate in plpgsql.
> ------------------------------------------------------------------------
> *From:* Steve Crawford <scrawford@pinpointresearch.com>
> *To:* pgsql-sql@postgresql.org
> *Sent:* Monday, March 26, 2012 9:08 PM
> *Subject:* Re: [SQL] how to concatenate in PostgreSQL
>
> On 03/24/2012 04:43 AM, Rehan Saleem wrote:
>> hi ,
>> how can we concatinate these lines and execute sql command
> In what? Psql? A PL/pgSQL function. C/Java/PHP/Python/Perl/Erlang/Lua?
>> setsql = 'select user,username, firstname '
>> set sql += ' lastname, cardno from table1 where userid=' + 5
>> exec(sqi)
>> where 5 is the userid from table1
>> thanks
>>
> Cheers,
> Steve
>
>
Yes, after about a decade of PostgreSQL use and forum participation I
think I know which forum this is. Sarcasm and biting at people who want
to help you is not a good way to make friends and get help on the forums.
If you meant PL/pgSQL then say it. It is not the same as SQL though the
syntax is generally similar. Look at DECLARE and BEGIN for starters.
I've seen too many threads get reset back to the start once some
incorrect assumptions get corrected to feel that up-front clarification
is a waste of time.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems is more
oriented to problem reporting than general questions but has helpful
advice nonetheless.
Back to the issue at hand...others have pointed out the || operator and
the issue with NULL. It appears you are doing a lot of conversion
requiring writing of PL/pgSQL functions. Spend a few minutes skimming:
http://www.postgresql.org/docs/current/static/plpgsql.html
As to the topic of executing the command including many examples see:
http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-D...
If you are writing functions that must use dynamically generated table
and column names, become familiar with the quote_ident, quote_literal
and quote_nullable functions.
Cheers,
Steve
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: scrawford@pinpointresearch.com, pk_rehan@yahoo.com
Subject: Re: how to concatenate in PostgreSQL
In-Reply-To: <4F71E6FF.6060204@pinpointresearch.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