Re: [SQL] Database diagram

2004-01-20 Thread Roberto Mello
t.ca/autodoc/ dbVisualizer - gratis, but not Free and many others. Search in freshmeat.net and google. -Roberto -- +----| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/L

Re: [SQL] postgresql and ColdFusion

2003-12-08 Thread Roberto Mello
On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote: > Hi, > How to call PostgreSql function from ColdFusion, if > that function returns result set using cursor? Through ODBC. Don't know it they have native access now. -Roberto -- +| Roberto Mel

Re: [SQL] Postgres with OpenSSL

2003-10-18 Thread Roberto Mello
#x27;s described in detail in the Administrator's Manual: http://www.postgresql.org/docs/7.3/static/ssl-tcp.html It's important to note that PostgreSQL has supported SSL connections for much longer than MySQL. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--

Re: [SQL] PL/PGSQL TUTORIAL

2003-10-11 Thread Roberto Mello
, blog, to an entire online education vertical application: dotLRN (www.dotlrn.org) -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/L

Re: [SQL] Case Insensitive comparison

2003-09-26 Thread Roberto Mello
next week, after my exams. -Roberto -- +----| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + -

Re: [SQL] Case Insensitive comparison

2003-09-24 Thread Roberto Mello
n > similar to NULLIF(). Use the standard coalesce(). -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + MONEY TALKS ... but all

Re: [SQL] logging messages from inside pgPLSQL routine?

2003-08-21 Thread Roberto Mello
he documentation mentions this in several places and examples. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + C

Re: [SQL] Porting from PL/SQL to PLPGSQL

2003-08-20 Thread Roberto Mello
ow can we convert them into PostGres. You can recompile to change the number of parameters. PG 7.3 can have up to 32 arguments by default, IIRC. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University

[SQL] PostgreSQL and Journaled File Systems

2003-08-10 Thread Roberto Mello
ks in advance, -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + If I only had a nickel for every time Window

Re: [SQL] Very strange 'now' behaviour in nested triggers.

2003-07-27 Thread Roberto Mello
rnt in corner cases, > like you were. > > Any comments? I think that is a preferred behavior. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software &a

Re: [SQL] pesky plpgsql

2003-04-03 Thread Roberto Mello
t;non-standard tab character"? Are you saying tab is non-standard or that there's some sort of weird tab character that could be being used in this case? I've always used tabs in my PL/pgSQL functions and it works just fine. -Roberto -- +|Roberto Mello -h

[SQL] Return type of triger functions from OPAQUE to TRIGGER in 7.3

2003-02-25 Thread Roberto Mello
ype of every trigger for TRIGGER (which means no 7.2 compatibility) or stay stuck in 7.2-land. Are there plans to make the behavior of CREATE OR REPLACE FUNCTION consistent with that of CREATE FUNCTION? Thanks, -Roberto -- +----| Roberto Mello -http://www.brasileiro.net/ |

Re: [SQL] get # of rows while doing SELECT with LIMIT at same time ?

2003-02-06 Thread Roberto Mello
ed chunk and cache it in RAM. Users usually only look at the first few pages, so it suffices for most cases. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Softwar

Re: [SQL] Trigger para fazer log

2003-02-06 Thread Roberto Mello
hamando outra função que o faça). -Roberto P.S.: Tomaz, you understood his question correctly :-) -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club -

Re: [SQL] to_date has beaten me...

2003-02-05 Thread Roberto Mello
ent with Oracle, evidently. > Next I'll be wondering why DECODE doesn't work... Because DECODE is non-standard AFAIK. You can use CASE WHEN in PostgreSQL, which IIRC, started being supported in Oracle 8.1.7. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |

Re: [SQL] Cross-database references

2003-01-28 Thread Roberto Mello
Look at the dblink module under the contrib section of PostgreSQL. It implements the feature you're looking for. -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Softwa

Re: [SQL] Getting multiple rows in plpgsql function

2003-01-24 Thread Roberto Mello
L documentation that show you how to do it. -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + And God said: E = ½mv²

Re: [SQL] Scheduling Events?

2003-01-23 Thread Roberto Mello
script that invokes psql with the appropriate queries 2) Schedule a cron job to the end of the month Each tool doing its own small task well done. -Roberto -- +----| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah Stat

Re: [SQL] SQL to list databases?

2003-01-23 Thread Roberto Mello
** List of databases Name | Owner| Encoding ++-- addresses | windozefoo | LATIN1 foobar | roberto| LATIN1 openacs-4 | roberto| LATIN1 template0 | postgres | LATIN1 template1 | postgre

Re: [SQL] Perform a Select on an Oracle Database from PG

2002-12-19 Thread Roberto Mello
cle and INSERT into PostgreSQL. That assumes the database structure has already been migrated. You might want to look at conversion tools in the PostgreSQL contrib tree (see ftp site) and related articles at http://techdocs.postgresql.org/ -Roberto -- +|Roberto Mello

Re: [SQL] Stored Procedure Problem

2002-12-12 Thread Roberto Mello
ot;). The part on returning record sets is only relevant to 7.3 -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/L

Re: [SQL] primary + foreign key

2002-12-12 Thread Roberto Mello
Read "An Introduction to Database Systems" by C.J. Date. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club

Re: [SQL] SQL syntax for concating values in different rows together

2002-12-10 Thread Roberto Mello
f the resolution to query the complaints table and return the concatenation of all the details. That way you could just: SELECT id, foo, bar, concat_resolution_details(id) FROM resolutions; I'd give it a shot at the function, but you didn't give the structure of the

Re: [SQL] Ran out of connections

2002-12-04 Thread Roberto Mello
he box." Oh, it's > free/open-source as well. I second that suggestion. Having used AOLserver for the past few years, it's a very nice application/web server with superb database support. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ +

Re: [SQL] Ran out of connections

2002-12-04 Thread Roberto Mello
out put of the ps command can be > seen at http://dominion.dyndns.org/~mdiehl/ps.txt Are you using PHP by chance? I've seen this behavior under Apache+PHP before. My "fix" (workaround rather) was to disable persistent connections. -Roberto -- +|Roberto Mello -http://www.b

Re: [SQL] changing the size of a column without dump/restore

2002-11-25 Thread Roberto Mello
update pg_attribute set atttypmod = 204 where attrelid = ( select oid from pg_class where relname = 'bar' ) and attname = 'foo'; -Roberto P.S: I don't know if this has any bad side effects. -Roberto -- +|Roberto M

Re: [SQL] Time difference without intervals

2002-11-10 Thread Roberto Mello
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote: > Roberto Mello <[EMAIL PROTECTED]> writes: > > Is there any way to make a timestamp difference operation not return an > > interval? I'd like to get hours, minutes and seconds only, not the "1 day&quo

[SQL] Time difference without intervals

2002-11-08 Thread Roberto Mello
al? I'd like to get hours, minutes and seconds only, not the "1 day" or whatnot. lbn-dev=# select now() - '2002-11-07 7:42'::timestamp; ?column? --- 1 day 02:01:57.987838 (1 row) Thanks, -Roberto -- +|Robert

Re: [SQL] CoreReader

2002-10-28 Thread Roberto Mello
On Fri, Oct 25, 2002 at 10:32:00PM -0500, John Ragan wrote: > > Does anybody know of CoreReader being run against > PostGresql? > > If so, I would appreciate knowing the results. What's CoreReader? -Roberto -- +----| Roberto Mello -http:

Re: [SQL] multiple databases

2002-10-28 Thread Roberto Mello
greSQL, called dblink, that allows it. Look at the contrib tree on the PostgreSQL archives. -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - h

Re: [SQL] Foreign character struggles

2002-10-25 Thread Roberto Mello
to. Thanks, -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + ---(end of broadcast)

Re: [SQL] Select table from other database

2002-10-21 Thread Roberto Mello
A? > (something like "SELECT * FROM A.X ...") See the dblink module in the PostgreSQL contrib tree (available via ftp. packages available). -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State

Re: [SQL] functions that return a dataset or set of rows

2002-10-18 Thread Roberto Mello
7.2 documentation). http://developer.postgresql.org/ -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + Bill Gates made $6.3

Re: [SQL] SELECT with INNER data bases

2002-10-10 Thread Roberto Mello
PostgreSQL contrib/ directory. See its documentation. And here goes the same as above, but in Portuguese :) O PostgreSQL não permite isso por padrão. Você pode usar 7.3 e schemas como foi sugerido, ou usar um módulo chamado dblink com 7.2. Esse módulo está no diretório contrib do PostgreSQL. Ve

[SQL] epoch to date

2002-10-03 Thread Roberto Mello
Hi all, Maybe I missed something obvious, but is there a built-in function to convert epoch to date? I couldn't find it in the documentation for extract and friends. Thanks, -Roberto -- +| Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Gra

Re: PROBLEM SOLVED RE: [SQL] please help with converting a view in oracle into postgresql readably code

2002-10-02 Thread Roberto Mello
th this > for a number of days now. Argh, that's right, I forgot the ENDs. Ugh! Shame on me. Glad that's working for you now. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University

Re: [SQL] please help with converting a view in oracle into postgresql readably code

2002-10-01 Thread Roberto Mello
x.php?functions-conditional.html Hope this works. -Roberto P.S.: Some indenting goes a long way through helping to understand your code. -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State University + + USU

Re: [SQL] Stored Procedures

2002-10-01 Thread Roberto Mello
ished through returning a cursor from the function. See the 7.3 documentation to see how to do that (AFAIK, this is not documented in the 7.2 docs, although it does work). In 7.3 you can return true record sets without the use of cursors. Again, see the docs for 7.3 in the developers site. -Roberto

Re: [SQL] [GENERAL] Monitoring a Query

2002-09-23 Thread Roberto Mello
ave GUC 'log_duration' which will show query duration. Forgive my ignorance here, but what is GUC? And how would I access the query duration? -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + Computer Science Graduate Student, Utah State Universi

Re: [SQL] [GENERAL] Monitoring a Query

2002-09-23 Thread Roberto Mello
ackage called "Developer Support" that shows you (among other things) how long a query took to be executed. Very good to finding out slow-running queries that need to be optimized. -Roberto -- +|Roberto Mello -http://www.brasileiro.net/ |--+ + USU Fre

Re: [SQL] License

2002-08-01 Thread Roberto Mello
ree Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer Itsdifficulttobeverycreativewithonlyfiftysevencharacters! ---(end of broadcast)---

Re: RES: [SQL] RES: [GENERAL] set DateStyle to 'SQL'

2002-07-29 Thread Roberto Mello
at http://br.groups.yahoo.com/group/postgresql-br/ The archives are searchable, so you could try there. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space

Re: [SQL] RES: [GENERAL] set DateStyle to 'SQL'

2002-07-26 Thread Roberto Mello
du/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer A .45 beats a royal flush EVERY TIME ---(end of broadcast)--- TIP 6:

Re: [SQL] Scan SQL

2002-07-23 Thread Roberto Mello
enerate the source in delphi, but I > need a sql specification (BNF, EBNF) and I do not know where to find it. You could look at how PostgreSQL does its parsing. The source code is open. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mell

Re: [SQL] Editor for pgsql

2002-07-22 Thread Roberto Mello
bian.org ("unstable" distribution) and unpacking them (Debian packages are just "ar" packages with extra headers). -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ h

Re: [SQL] Editor for pgsql

2002-07-22 Thread Roberto Mello
QL installations all the time. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer Microsoft has been doing a really bad

Re: [SQL] manipulating the database in plsql

2002-07-08 Thread Roberto Mello
an. A PL/pgSQL function is already part of the database it belongs to. It doesn't need a handle. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.ed

Re: [SQL] newbie question

2002-07-08 Thread Roberto Mello
tp://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer Why trying to DRINK and DRIVE, while you can SMOKE and FLY? -

Re: [SQL] How do i return a dataset from a stored procedure

2002-07-05 Thread Roberto Mello
achive that effect by returning a cursor in PG 7.2 (the section on returning cursors is ommitted from the current docs in www.postgresql.org/idocs, so you need to look at the developer docs - see www.us.postgresql.org). -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Clu

Re: [SQL] pl/pgsql capabilities?

2002-07-01 Thread Roberto Mello
u currently have, as far as I could understand it. I didn't read the procedure very attentively because it's horribly written in all caps, and my eyes started scrambling the letters half way through. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--

Re: [SQL] pl/pgsql capabilities?

2002-07-01 Thread Roberto Mello
res/plpgsql-cursors.html -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer I wonder if Singapore has any c

Re: [SQL] graphical interface - admin

2002-07-01 Thread Roberto Mello
to -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer * * * <- Tribbles § § § <- teenage mutant ninja tribbles ---

Re: [SQL] PL/pgSQL syntax for strings

2001-11-01 Thread Roberto Mello
know if the \' way of escaping quotes works. I never tried within a PL/pgSQL function. My guess is that it doesn't. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.

Re: [SQL] Primary key with oid + name : error, which solution ?

2001-10-31 Thread Roberto Mello
e non-standard. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer NY cops go bar-hopping; LA cops go night-clubbing.

Re: [SQL] can't update 'c:\windows'

2001-10-23 Thread Roberto Mello
Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Windows is not the problem. Ignorance is the problem. ---(end of broadcast)

Re: [SQL] SQL-Programmer tool and field%type support

2001-10-08 Thread Roberto Mello
You can use function overloading if you need the same function to return different types. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.e

Re: [SQL] CHECK problem really OK now...

2001-09-24 Thread Roberto Mello
e". Give it for free and you'll > get plenty of it when you need some. I couldn't agree more! -Roberto -- +| Roberto Mello - http://www.brasileiro.net |+ Computer Science, Utah State University -http://www.usu.edu USU Free Software &a

Re: [SQL] Checking for table existence

2001-09-17 Thread Roberto Mello
Table "blah" Attribute | Type | Modifier ---+--+--- something | timestamp with time zone | default 'now' name | character(50) -Roberto -- +| Roberto Mello - http://www.brasileiro.net |+

Re: [SQL] Converting epoch to timestamp?

2001-08-01 Thread Roberto Mello
+ '996654342 seconds'::interval; > ?column? > > 2001-08-01 08:25:42+01 > (1 row) Duh! Guess I could have thought of that. Thanks a lot. -Roberto -- +| Roberto Mello - http://www.brasileiro.net |---

[SQL] Converting epoch to timestamp?

2001-07-31 Thread Roberto Mello
I searched the docs for function to convert epoch to timestamps but couldn't find any. Are there any? Thanks, -Roberto -- +----| Roberto Mello - http://www.brasileiro.net |+ Computer Science, Utah State University - http://www.usu.edu

Re: [SQL] Get the tables names?

2001-07-20 Thread Roberto Mello
ot; part is to avoid getting the PostgreSQL internal tables in the output. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Develo

Re: [SQL] Re: [INTERFACES] distinguishing different database connections

2001-07-10 Thread Roberto Mello
-Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Dente lupus, cornu taurus petit. ---(end

Re: [SQL] Group by date_part

2001-07-10 Thread Roberto Mello
but can't you just add a: CASE WHEN count(*) > 0 THEN count(*) ELSE 0 END AS count -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynami

Re: [SQL] CREATE TYPE function examples

2001-07-10 Thread Roberto Mello
t, > hint...) How so? Would you please elaborate? I'm note familiar with the update. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu

[SQL] CREATE TYPE function examples

2001-07-10 Thread Roberto Mello
INPUT = my_procedure_1, OUTPUT = my_procedure_2); What would the functions my_procedure_1 and my_procedure_2 look like? Thanks, -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net

[SQL] PL/TclU

2001-07-06 Thread Roberto Mello
I've heard quite a bit about PL/TclU, but what's the difference between that and regular PL/Tcl?? Thanks, -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.ne

Re: [SQL] Changing PL/pgSQL triggers

2001-06-21 Thread Roberto Mello
Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer *> -| <- Tribble Archery ---(end of broadcast)-

Re: [SQL] About primary keys.

2001-06-19 Thread Roberto Mello
sileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36 -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer TAG

Re: [SQL] Better Archives?

2001-06-18 Thread Roberto Mello
at fts.postgresql.org -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Windows? HA! CD\WINDOWS. DELETE *.* AH! That

Re: [SQL] PL/PGSQL

2001-06-12 Thread Roberto Mello
lc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Death to all fanatics!!! ---(end of broadcast)--- TIP 2: you

Re: [SQL] Tutorial : using foreign keys, retrictions etc

2001-06-06 Thread Roberto Mello
or examples of functions, head to http://www.brasileiro.net/postgres -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer

Re: [SQL] php-nuke

2001-06-06 Thread Roberto Mello
du USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer I wonder what this button does? *&^(&^)#@$*&_% NO CARRIER --

Re: [SQL] PGAccess/pgplsql Blues

2001-06-01 Thread Roberto Mello
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer I'm only a droid and not very knowledgeable about such things. ---

[SQL] Large Objects Documentation

2001-05-25 Thread Roberto Mello
| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Be a pessimist. A pessimist is never disappointed. ---(en

Re: [SQL] Give me a suggestion 'START WITH .. CONNECT BY'.

2001-05-16 Thread Roberto Mello
n use to do this. The OpenACS folks used that approach to port Oracle's CONNECT BY to PostgreSQL, so you could probably ask them over at openacs.org/bboard. -Roberto P.S: I plan to add this to my expanded "Porting From Oracle" chapter of the documentation. -- +| htt

Re: [SQL] Exp/Imp Problems...

2001-05-16 Thread Roberto Mello
the PostgreSQL database. For Oracle support you should look for an Oracle forum/list or call their support. http://www.arsdigita.com/bboard (web/db forum) has lots of Oracle users. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto

Re: [SQL] Is this possible?

2001-05-11 Thread Roberto Mello
| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer "Data! I thought you were dead!" "No, Sir. I rebooted." --

Re: [SQL] Postgres function library

2001-05-11 Thread Roberto Mello
tions there. The more we have, the better. I am going to improve the site in a few days. http://www.brasileiro.net/postgres -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileir

[SQL] Re: [HACKERS] Problems in porting from Oracle to Postgres

2001-05-11 Thread Roberto Mello
Again, you're giving way too little detail. What error? What are you trying? Without this, it's very hard to help. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://w

Re: [SQL] Re: Escape Quotes

2001-05-10 Thread Roberto Mello
On Fri, May 11, 2001 at 01:17:41PM +1000, Keith Gray wrote: > > The problem is in ipqsql... What the heck is ipsql?? -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.bras

Re: [SQL] Information passing, Perl, Unix and Postgresql Database

2001-05-09 Thread Roberto Mello
-Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer _ _ _ _ _ _ || < domino effect at work --

Re: [SQL] How to encode and decode password in pgsql !!

2001-05-03 Thread Roberto Mello
I usually do the encrypting in the client application (AOLserver, PHP), store the encrypted password, when the user comes back and enters the password I encrypt it and test it against what's on the database. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux

Re: [SQL] plpgsql

2001-04-20 Thread Roberto Mello
c.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer If at first you don't succeed, destroy all evidence that you tried. ---(end of broadcast)-

Re: [SQL] any proper benchmark scripts?

2001-04-19 Thread Roberto Mello
ich one will survive the fall? Comparing MySQL to PostgreSQL, Oracle or any other real database is like comparing DOS with UNIX, or Emacs with an orange. -Roberto Mello -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Compute

Re: [SQL] Postgresql to Access

2001-04-19 Thread Roberto Mello
hat should I do. Look at the article an http://techdocs.postgresql.org -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Develope

Re: [SQL] maybe Offtopic : PostgreSQL & PHP ?

2001-04-18 Thread Roberto Mello
OT longer. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Tetris tagline: @@ o@o @oo oo@

Re: [SQL] maybe Offtopic : PostgreSQL & PHP ?

2001-04-18 Thread Roberto Mello
penNSD world -- where ALL connections are persistant, pooled, and dstributed among threads -- I'd be interested in knowing the quirks of persistant connections in PHP. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Scie

Re: [SQL] Where are the 7.1 RPM's?

2001-04-17 Thread Roberto Mello
-Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer -°*'. (Explosive Tagline)

Re: [SQL] Re: DB porting questions...

2001-04-17 Thread Roberto Mello
handles properly doing auto > increments with the SERIAL type, and does the set/enum conversions? What do you mean by "propely doing auto increments"? What's the problem you are having? -Roberto -- +| http://fslc.usu.edu USU Free Softwar

Re: [SQL] Using Random Sequence as Key

2001-04-16 Thread Roberto Mello
| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Oh my GOSH! A Prompt!!! HELP A PROMPT ! HELP ! ---

Re: [SQL] Debian Package problems

2001-04-13 Thread Roberto Mello
l for a 16-bit patch to an 8-bit operating system > originally coded for a 4-bit microprocessor, written by a 2-bit > company that can't stand for 1 bit of competition. :) Remarkably accurate! -Roberto -- +| http://fslc.usu.edu USU Free Software &

Re: [SQL] Debian Package problems

2001-04-13 Thread Roberto Mello
On Fri, Apr 13, 2001 at 09:00:45AM -0600, Roberto Mello wrote: > If I try to connect through psql, it asks me for the password again. > It looks like it's using password auth instead of ident auth, which used > to be the default. > There's nothing pointed in the

[SQL] Debian Package problems

2001-04-13 Thread Roberto Mello
at or anything. I've looked. Thanks, -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer

Re: [SQL] Function overlaps_interval

2001-04-12 Thread Roberto Mello
ot;PostgreSQL Powered" button! We've been getting many hits from techdocs.postgresql.org, which shows that many are going to techdocs looking for solutions to common problems. Very useful. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ R

[SQL] Timezone conversion

2001-04-11 Thread Roberto Mello
http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Ad astra, per ardua nostra. ---(end of broadcast)

Re: [SQL] Sorting and then...

2001-04-09 Thread Roberto Mello
select max(id) from ; -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Backup is for whimps!

Re: [SQL] Calling functions inside a function: behavior

2001-04-02 Thread Roberto Mello
et of the functions here? -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer TOFU -> Text Oben Fullquote Unten -

Re: [SQL] Oracle -> Postgresql migration

2001-03-28 Thread Roberto Mello
w to change some Oracle'isms (e.g. nvl, decode, etc.) to PostgreSQL, sticking to the standard where possible. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http:/

Re: [SQL] Help

2001-03-25 Thread Roberto Mello
s jsp files and PostgreSQL does not have a Java virtual machine. But you can use PostgreSQL from your Java program by using JDBC. Look for Jakarta/Tomcat for an open source servlet container. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Rober

Re: [SQL] drop table in PL/pgSQL

2001-03-23 Thread Roberto Mello
u can't roll back. -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer "Carrier detected." Go to the dentist...

  1   2   >