Thread

1. Query Limitations

   Keith Gray <keith@heart.com.au> — 2001-03-07T04:40:17Z

   PostgreSQL 6.4 seems to have limitations in Query Length when I 
   
   "CREATE VIEW" ... is this limit defined
   
   further, when I create a query on a query... it seems to compound
   the queries and reach the limit sooner!!
   
   Is this limit programmable?
   
   Is it default higher in 7.0?
   
   What is the most stable 7.X release?
   
   
   
   
   
   
   Keith
   
   

2. Re: Query Limitations

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-03-07T04:56:02Z

   > PostgreSQL 6.4 seems to have limitations in Query Length when I 
   > 
   > "CREATE VIEW" ... is this limit defined
   > 
   > further, when I create a query on a query... it seems to compound
   > the queries and reach the limit sooner!!
   > 
   > Is this limit programmable?
   > 
   > Is it default higher in 7.0?
   
   Yes.
   
   > 
   > What is the most stable 7.X release?
   
   7.0.3
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
   
   

3. how to get info of function

   Jie Liang <jliang@ipinc.com> — 2001-03-07T17:09:32Z

   Hi,
   
   What system table hold info of user defined function??
   Acturally , I want to know how to retrive the defination of a function
   from its name.
   
   
   Thankes.
   
   
   
   Jie LIANG
   
   St. Bernard Software
   
   10350 Science Center Drive
   Suite 100, San Diego, CA 92121
   Office:(858)320-4873
   
   jliang@ipinc.com
   www.stbernard.com
   www.ipinc.com