FAQ
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

Search Discussions

  • Tom Lane at Mar 16, 2011 at 2:22 pm

    siva kiran balijepalli 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMar 16, '11 at 6:48a
activeMar 16, '11 at 2:22p
posts2
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase