Received: from omega.bkc.lv (omega.bkc.lv [195.244.128.2]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA78504 for ; Fri, 3 Mar 2000 03:49:49 -0500 (EST) (envelope-from emils@mail.usis.bkc.lv) Received: from mail.usis.bkc.lv (mail.usis.bkc.lv [195.244.132.2]) by omega.bkc.lv (8.9.3/8.9.1) with ESMTP id KAA18344 for ; Fri, 3 Mar 2000 10:49:47 +0200 (EET) Message-Id: <200003030849.KAA18344@omega.bkc.lv> Received: from USIS-RIGA/SpoolDir by mail.usis.bkc.lv (Mercury 1.44); 3 Mar 100 10:52:23 EET Received: from SpoolDir by USIS-RIGA (Mercury 1.44); 3 Mar 100 10:52:14 EET From: "Emils Klotins" Organization: USIS Riga To: pgsql-sql@postgreSQL.org Date: Fri, 3 Mar 2000 10:51:46 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [SQL] date_part - multiple values in format? Priority: normal References: <200003021508.RAA08695@omega.bkc.lv> In-reply-to: <8873.952011963@sss.pgh.pa.us> X-PM-Encryptor: QDPGP, 4 X-mailer: Pegasus Mail for Win32 (v3.12b) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [2 Mar 00,, 10:46] Tom Lane wrote: > "Emils Klotins" 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-----