Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-23 Thread Manuel Lemos
ters to me because my applications market is larger if do not depend on a particular DBMS specific features. >Are functions not available in other SQL dialects? I don't know. I just don't want to rely on something that advanced for so little use. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-23 Thread Manuel Lemos
way, I don't see why I can't configure those requirements during PostgreSQL build, especially when in past versions it worked with less shared memory. I wonder if isn't there a way to hack PostgreSQL source to make it work with less shared memory as in past versions. Reg

Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-22 Thread Manuel Lemos
0 >(3 rows) Yes, that's what I need as long that last a column is not a NULL because that is what I get with joins. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://ww

RE: [GENERAL] Can't put sub-queries values in queries results?

2000-07-22 Thread Manuel Lemos
OP TABLE t1; DROP TABLE t2; CREATE TABLE t1 (f1 INT); INSERT INTO t1 (f1) VALUES (0); INSERT INTO t1 (f1) VALUES (1); INSERT INTO t1 (f1) VALUES (2); CREATE TABLE t2 (f2 INT); INSERT INTO t2 (f2) VALUES (0); INSERT INTO t2 (f2) VALUES (0); INSERT INTO t2 (f2) VALUES (1); SELECT f1, COUNT(f2) FROM

[GENERAL] Can't put sub-queries values in queries results?

2000-07-21 Thread Manuel Lemos
em to understand this. I wonder if this is a limitation or I am doing something wrong. If I can't do what I want this way, I wonder if is there some other way to do it besides making two queries by passing the values from one to the other. Regards, Manuel Lemos Web Programming Components

Re: [GENERAL] International Address Format Standard

2000-06-18 Thread Manuel Lemos
^[^ \t\n\r]+ left ^[0-9]{4}$ left 4 ^[0-9]{3}$ 3 ^[^ \t\n\r]+ uppercase Regards, Manuel Lemos Web Programming Comp

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-24 Thread Manuel Lemos
Hello Ed, On 24-Apr-00 17:10:21, you wrote: >Manuel Lemos wrote: >> >> >Plus if you get a warning/error, Postgresql _requires_ you to rollback, >> >whereas many other databases don't. >> >> That's what Metabase expects. When there is

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-21 Thread Manuel Lemos
ses some techniques of regression testing to verify the conformance of any driver. This already helped to fix some subtle bugs in the existing drivers but it will help further to detect faults in future drivers and problemns when interfacing with new releases of databases. Regards, Manu

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-19 Thread Manuel Lemos
ve, or for instance transactions are not supported at all, they are not emulated. For instance, if you need transactions, there is no magic that will emulate that for instance in MySQL. So, use another database. You can query any Metabase driver if a particular feature is supported or not. If you still try to call functions that depend on unsupported feature they will fail returning an error. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-17 Thread Manuel Lemos
tgreSQL, example schemas and installation scripts, user manual and tutorial documents. http://phpclasses.UpperDesign.com/browse.html/package/20 Enjoy, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL

Re: [GENERAL] Web-based PSQL?

2000-04-05 Thread Manuel Lemos
nd a tutorial document to get you started quickly with Metabase and well all the drivers and other package classes. Enjoy, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] -- E-mail: [EMAIL PROTECTED] URL: http://www.mlemos.e

Re: [GENERAL] RE: postgresql and web transactions

2000-02-18 Thread Manuel Lemos
time, you'd better find other solutions besides transactions. For instance if you want to hold on a ticket reservation for a client before he decides to purchase it, you should not use transactions to lock the reservation. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at:

[GENERAL] Can't I create indexes on BOOL columns?

1999-12-13 Thread Manuel Lemos
x27;)\g CREATE template1=> CREATE INDEX users_notify ON users (notify_any,notify_new)\g ERROR: Can't find a default operator class for type 16 However, if I change the BOOL type to CHAR (1) it works. Is this a bug? A configuration problem? What? Regards, Manuel Lemos Web Programming Components

[GENERAL] Build without generating shared libraries

1999-07-29 Thread Manuel Lemos
Hello, Is it possible to build PostgreSQL without generating to shared libraries? If so, how? If not, are there any plans to support that as a configure option? Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED

[GENERAL] PostgreSQL EndTransactionBlock and not inprogress/abort state

1999-03-14 Thread Manuel Lemos
abort state Anybody experienced anything like this with PostgreSQL 6.4.2? Regards, Manuel Lemos E-mail: [EMAIL PROTECTED] URL: http://www.e-na.net/the_author.html PGP key: finger:[EMAIL PROTECTED] --

[GENERAL] Negating the list of selected rows of a join

1999-03-14 Thread Manuel Lemos
works the way I want all the time, even for the case when table_b is empty? Regards, Manuel Lemos E-mail: [EMAIL PROTECTED] URL: http://www.e-na.net/the_author.html PGP key: finger:[EMAIL PROTECTED] --