Re: [SQL] [HACKERS] Cursors and backwards scans and SCROLL

2003-03-10 Thread Hannu Krosing
Tom Lane kirjutas P, 09.03.2003 kell 22:35: > However, this is going to create backwards-compatibility issues. > We have a few options for what to do: > > 1. Enforce the SQL spec requirement: error out if backwards fetch is > done when SCROLL wasn't given. But this will surely break a lot > of e

[SQL] Re: [DOCS] Extending PostgreSQL Using C

2001-03-12 Thread Hannu Krosing
Boulat Khakimov wrote: > Hi, > > Im writing a C function for PG to do one way encryption using crypt. > Here is the source code > > it gives me this error > > ERROR: Can't find function encrypt in file /[full path here]/encrypt.so > > > Why do I get this error > Any ideas? Can _postg

Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB?

2001-03-02 Thread Hannu Krosing
Jaruwan Laongmal wrote: > I had deleted a very large number of records out of my SQL table in order to > decrease the harddisk space. But after I use command 'ls -l > /usr/local/pgsql/data/base/', it is found that the size of concerning files > do not reduce due to the effect of 'delete' SQL com

[SQL] Re: [INTERFACES] outer join in PostgreSql

2001-01-17 Thread Hannu Krosing
Thomas Lockhart wrote: > > Mauricio Hipp Werner wrote: > > > > I need help, which is the symbol used in postgreSql to carry out the outer > > join. > > > > in oracle the is used (+) > > in sybase the is used * and > > in postgreSql? > > The PostgreSQL outer join is accomplished using SQL92 synt

Re: [INTERFACES] Re: [SQL] improve performance

2001-01-16 Thread Hannu Krosing
Tom Lane wrote: > > > I've heard lots of people want to increase BLCKSZ, but you're the first > one who ever wanted to reduce it. You sure you want to do this? It's > going to make the maximum row length uncomfortably short. And it may even not work, as some system tables (that are also affec