Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group