Running query from scratch with something like exec function?
Posted
by Steel Plume
on Stack Overflow
See other posts from Stack Overflow
or by Steel Plume
Published on 2010-03-15T23:24:02Z
Indexed on
2010/03/15
23:29 UTC
Read the original article
Hit count: 131
Filed under:
postgresql
|query
Hi, is it possible to make something similar to the following with Postgresql without using a function?
pseudo sql code:
select * from sometable where somecol = somevalue AND someothercol IN exec( 'select something from exclusionlist' )
My primary intention is to build up a table with predefined queries to call inside a where clause
pseudo sql code: select * from sometable where somecol = somevalue AND someothercol IN exec( select query from predefinedqueries where id=someid )
© Stack Overflow or respective owner
