On Fri, Oct 14, 2011 at 10:43 AM, Thomas Girault <toma(dot)girault(at)gmail(dot)com> wrote:
> I am now trying to limit the number of results in the view according
> to the global value K :
>
> CREATE OR REPLACE VIEW filtered_employees AS
>    SELECT *, get_mu() as mu
>    FROM employees
>    ORDER BY mu DESC
>    LIMIT K;

Well, SQL, our our dialect of it anyway, doesn't have global
variables.  So I think the above is going to throw a syntax error.
You may have global variables in your C code, but those won't be
visible from the SQL level.

In general, I think you'd be better off not relying on C global
variables either, and instead passing the values you need as function
arguments.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

• LIMITing number of results in a VIEW with global variables at 2011-10-14 14:43:01 from Thomas Girault

Responses

• Re: LIMITing number of results in a VIEW with global variables at 2011-10-15 11:55:35 from Thomas Girault

pgsql-hackers by date

Next:	From: Robert Haas	Date: 2011-10-15 10:49:43
	Subject: Re: Call stacks and RAISE INFO
Previous:	From: Nathan Boley	Date: 2011-10-15 10:47:16
	Subject: Re: WIP: collect frequency statistics for arrays