diference between calling a function in select clause and from clause

From: siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: diference between calling a function in select clause and from clause
Date: 2011-03-16 06:47:52
Message-ID: AANLkTikaXP1j33_zQeyr0ES3yS71EAEe+ayQexqsncjN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi every body

What i sthe difference between these two sql statements?

select * from function-name();
select function-name();

The outputs of these will be same but when should we use particular one.

please reply

regards
sivakiran.B

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Haris 2011-03-16 14:04:56 foreign key
Previous Message Tom Lane 2011-03-16 00:15:31 Re: syntax error on WHERE clause...