Re: diference between calling a function in select clause and from clause

siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com> writes:
> 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.

If the function returns a set (multiple rows) then the first is
considered better practice. If not, take your pick.

regards, tom lane