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
--
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
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
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
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
^[^ \t\n\r]+
left
^[0-9]{4}$
left
4
^[0-9]{3}$
3
^[^ \t\n\r]+
uppercase
Regards,
Manuel Lemos
Web Programming Comp
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
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
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
--
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
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
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:
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
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
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]
--
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]
--
16 matches
Mail list logo