Re: What is || doing

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: What is || doing
Date: 2011-06-27 13:13:46
Message-ID: 20110627151346.091bab78@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 27 Jun 2011 14:59:30 +0200, Frank Lanitz <frank(at)frank(dot)uvena(dot)de> wrote:

This is a concatenation operator; in this case 'ba_' is assembled with var foo
and '_pr_'.
eg: if foo = 'by', the resulting string is: 'ba_by_pr_'.

> SELECT 'ba_'|| foo || '_pr_'

--
Honest, officer, had I known my health was in jeopardy, why, I'd never have
lit one!

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tim Landscheidt 2011-06-27 13:18:24 Re: What is || doing
Previous Message Thom Brown 2011-06-27 13:12:08 Re: What is || doing