Re: SQL questiom

2022-01-21 Thread Jacob Bunk Nielsen
haman...@t-online.de writes: > I am using a query pretty often that looks like > SELECT <> WHERE <> AND > <> > > Is there a way (with sql or plpgsql) to convert that into > SELECT myquery('<>') I would solve that by creating a view like: CREATE VIEW some_view_name AS SELECT <> WHERE <>; See

Re: SQL questiom

2022-01-21 Thread Thomas Boussekey
Le ven. 21 janv. 2022 à 11:14, a écrit : > > > Hi, > > I am using a query pretty often that looks like > SELECT <> WHERE <> AND > <> > > Is there a way (with sql or plpgsql) to convert that into > SELECT myquery('<>') > > Kind regards > Wolfgang Hamann > > > > Hello Wolfgang, You can use a FUNC

SQL questiom

2022-01-21 Thread hamann . w
Hi, I am using a query pretty often that looks like SELECT <> WHERE <> AND <> Is there a way (with sql or plpgsql) to convert that into SELECT myquery('<>') Kind regards Wolfgang Hamann