On Fri, Oct 14, 2011 at 10:43 AM, Thomas Girault <toma.gira...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
