[SQL] CTAGS for PL/pgSQL ?

2013-08-28 Thread Charles Sheridan
Does anyone know if there are any CTAGS extensions or variants that support PL/pgSQL ? I use exuberant-ctags which does not support it, and a web search does not return anything promising. (I sent this same email to -novice the list, but this list seems more appropriate). Regards, Charles

Re: [SQL] Is there a way to build a query based on data in a table?

2013-08-28 Thread Brice André
Hello, >From what I know, in pure SQL, it is not possible to perform what you want. But it is feasible in PL/pgSQL (and this script language is supported by default by postgresql...). Regards, Brice 2013/8/28 Herouth Maoz : > Hello. > > I want to run an automatic archiving SQL script, that look

[SQL] Is there a way to build a query based on data in a table?

2013-08-28 Thread Herouth Maoz
Hello. I want to run an automatic archiving SQL script, that looks at a meta-table containing data about the tables to be archived. Basically, suppose I have this data in the meta-table: table_name varchar(100) datetime_column_name varchar(100) archive_interval interval Like this: public.foo