Re: What is || doing - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: What is || doing
Date
Msg-id 20110627151346.091bab78@anubis.defcon1
Whole thread Raw
In response to What is || doing  (Frank Lanitz <frank@frank.uvena.de>)
Responses Re: What is || doing
List pgsql-novice
On Mon, 27 Jun 2011 14:59:30 +0200, Frank Lanitz <frank@frank.uvena.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!

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: What is || doing
Next
From: Frank Lanitz
Date:
Subject: Re: What is || doing