X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6EF30D1B538 for ; Tue, 21 Oct 2003 18:59:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 29205-01 for ; Tue, 21 Oct 2003 15:59:22 -0300 (ADT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 49FF3D1B4F6 for ; Tue, 21 Oct 2003 15:59:21 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 1AC1iz-000GLC-0W; Tue, 21 Oct 2003 19:59:22 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id C4BC01791B; Tue, 21 Oct 2003 19:59:20 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 201011791A; Tue, 21 Oct 2003 19:59:20 +0100 (BST) From: Richard Huxton To: dsankaran@ivesia.com (Dharan), pgsql-sql@postgresql.org Subject: Re: Writing the SQL queries inside Functions and operators Date: Tue, 21 Oct 2003 19:59:18 +0100 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310211959.18560.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/277 X-Sequence-Number: 15677 On Tuesday 21 October 2003 08:34, Dharan wrote: > Hi Friends, > > > What is the use of user defined operators, as functions also perform > the same job as an operator Easier to write. Compare: 'hello ' || ' there ' || 'everyone' with text_concat('hello', text_concat('there', text_concat('everyone') ) ) -- Richard Huxton Archonet Ltd