Thread: Writing the SQL queries inside Functions and operators

Hi Friends,


What is the use of user defined operators, as functions also perform
the same job as an operator


thanks in advance

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