Home > mailing lists

diference between calling a function in select clause and from clause - Mailing list pgsql-novice

From	siva kiran balijepalli
Subject	diference between calling a function in select clause and from clause
Date	March 16, 2011 06:48:01
Msg-id	AANLkTikaXP1j33_zQeyr0ES3yS71EAEe+ayQexqsncjN@mail.gmail.com Whole thread Raw
Responses	Re: diference between calling a function in select clause and from clause (Tom Lane <tgl@sss.pgh.pa.us>)
List	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

From: Tom Lane
Date: 16 March 2011, 00:15:41
Subject: Re: syntax error on WHERE clause...

From: "Haris"
Date: 16 March 2011, 14:05:07
Subject: foreign key