[SQL] pgsql embedded again!

2001-10-22 Thread Esteban Gutierrez Abarzua
hi. I still have the data type problem. I am working with the postgresql system catalog

[SQL] cast

2001-10-22 Thread Esteban Gutierrez Abarzua
hi. I wanna to make a query on this table(postgres system catalog): Attribute | Type| Modifier --+---+-- relname | name | reltype | oid | relowner | integer | relam| oid | relpages | integer | reltup

Re: [SQL] GROUPING

2001-10-20 Thread Esteban Gutierrez Abarzua
On Sat, 13 Oct 2001, Timothy J Hitchens wrote: > It's been a while since I used postgresql but today I have converted one > of my web apps but with one small problem. I goto do a group as > designed and executed in mysql and I get told that this and this must be > part of the aggreate etc I am p

[SQL] sql + C

2001-10-05 Thread Esteban Gutierrez Abarzua
hi. who knows about C embebed (postgres + C)? I have the program: #include EXEC SQL BEGIN DECLARE SECTION; VARCHAR base[50]; EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE sqlca; EXEC SQL DECLARE C77 CURSOR FOR select datname from pg_user,pg_database where usename= :user and datdba=use

[SQL] jdbc driver

2001-10-02 Thread Esteban Gutierrez Abarzua
hi. who to knows about the java + postgresql (jdbc)? I need to know where can I get the driver for conection postgres and java 1.2? thanks. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropr

[SQL] simple question!

2001-09-27 Thread Esteban Gutierrez Abarzua
hi. I have a simple question! is there a command intersect? I mean exist a union command, but I don't know if exist a intersect command. thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

[SQL] explain command

2001-09-24 Thread Esteban Gutierrez Abarzua
00..1.06 rows=6 width=4) EXPLAIN the cost query time is 1.06?1.06..seconds or milliseconds thanks friends! bye Esteban Gutierrez Abarzua Chillan- Chile ---(end of broadcast)-

[SQL] query time

2001-09-13 Thread Esteban Gutierrez Abarzua
Hi I am Esteban from Chile! I need to know.. How can I get running query time ? I mean . is there any function? I hope the answer in english or spanish? thanks! ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? ht