Re: [SQL] CTAGS for PL/pgSQL ?

2013-08-29 Thread Charles Sheridan
On 13-08-29 9:00 AM, Luca Ferrari wrote: On Thu, Aug 29, 2013 at 3:33 PM, Bruce Momjian wrote: Uh, I think Vim can use etags, no? Isn't etags Exuberant Ctags? The Exuberant Ctags's FAQ mentions Vim: I was referring to the etags shipped with emacs, that even if does not support (explicitly)

Re: [SQL] CTAGS for PL/pgSQL ?

2013-08-29 Thread Luca Ferrari
On Thu, Aug 29, 2013 at 3:33 PM, Bruce Momjian wrote: > Uh, I think Vim can use etags, no? Isn't etags Exuberant Ctags? The > Exuberant Ctags's FAQ mentions Vim: > I was referring to the etags shipped with emacs, that even if does not support (explicitly) sql seems to work for a very simple te

Re: [SQL] Using regexp_matches in the WHERE clause

2013-08-29 Thread David Johnston
spulatkan wrote > so following is enough to get the rows that matches regular expression > This is bad form even if it works. If the only point of the expression is to filter rows it should appear in the WHERE clause. The fact that regexp_matches(...) behaves in this way at all is, IMO, a flaw

Re: [SQL] CTAGS for PL/pgSQL ?

2013-08-29 Thread Bruce Momjian
On Thu, Aug 29, 2013 at 08:18:03AM -0500, Charles Sheridan wrote: > > >>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. > >As far as I know,

Re: [SQL] CTAGS for PL/pgSQL ?

2013-08-29 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. As far as I know, the quick answer is NO. However I made a few simple tests with etags and it seems to wo

Re: [SQL] Using regexp_matches in the WHERE clause

2013-08-29 Thread spulatkan
I noticed that regexp_matches already returns the rows which matches the regular expression now when I make a full table select query but if I make a search with regexp_matches, it only returns rows that matches regular expression on pgadmin the column type is shown as text[] thus I also do no

Re: [SQL] CTAGS for PL/pgSQL ?

2013-08-29 Thread Luca Ferrari
On Wed, Aug 28, 2013 at 5:08 PM, Charles Sheridan wrote: > 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. As far as I know, the quick answer is NO.