Re: [SQL] date_part - multiple values in format? - Mailing list pgsql-sql

From Emils Klotins
Subject Re: [SQL] date_part - multiple values in format?
Date
Msg-id 200003030849.KAA18344@omega.bkc.lv
Whole thread Raw
In response to Re: [SQL] date_part - multiple values in format?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

[2 Mar 00,, 10:46] Tom Lane wrote:

> "Emils Klotins" <emils@mail.usis.bkc.lv> writes:
> > Will there be a possibility of string concatenation in 7.x so that 
> > I don't have to put all the concats in brackets? (ie. currently I 
> > have to: ((((X || Y) || Z ) || A) || B) 
> > which is of course also rather clumsy and leads to lots of 
> > typos in case of more complex expressions.
> What?
> regression=# select 'a'::text || 'b'::text || 'c'::text;
>  ?column?
> ----------
>  abc
> (1 row)
> 6.5.3 behaves the same ...

Sorry about that. I don't remember at which version I did have 
to use the form of concatenation I mentioned (6.4.x? 6.5.2?), 
but yes, 6.5.3 seems to work fine without brackets.

Emils

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.2 -- QDPGP 2.61a
Comment: http://community.wow.net/grt/qdpgp.html

iQA/AwUBOL9gcN0sxa1MAPWHEQL0cwCdEvOCrVXWN6sETUkFQhxrIocwRv8AoIM5
d7tOGK/m8JJkbJ7seNk35ohk
=yLXB
-----END PGP SIGNATURE-----


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] date_part - multiple values in format?
Next
From: Kyle Bateman
Date:
Subject: 7.0beta bug (or feature)?