Postgres Pro
Downloads
Home   >   mailing lists

Re: Writing the SQL queries inside Functions and operators - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Writing the SQL queries inside Functions and operators
Date
Msg-id 200310211959.18560.dev@archonet.com
Whole thread Raw
In response to Writing the SQL queries inside Functions and operators  (dsankaran@ivesia.com (Dharan))
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: how to create a multi columns return function ?
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] Alias-Error