y. Anybody has any ideas or worked with CREATE
AGGREGATE before?
Sorry about the long email and TIA.
-Roberto Mello
--
Roberto Mello, [EMAIL PROTECTED] - GNU/Linux Reg.User #96240
Computer Science - Utah State University
USU Free Software and GNU/Linux Club, President
http://fslc.usu.edu - http://www.brasileiro.net/roberto
cause transactions are not supported
in functions (anybody knows when will this be around?).
Thanks,
-Roberto Mello
--
Roberto Mello, [EMAIL PROTECTED] - GNU/Linux Reg.User #96240
Computer Science - Utah State University
USU Free Software and GNU/Linux Club, President
http://fslc.usu.edu -
Hi all,
I am part of the team that's porting the ArsDigita Community System
(ACS), a toolkit to create community-oriented db-backed websites, from
Oracle to PostgreSQL. We call the projet OpenACS.
We are thinking of using PG 7.1b for the port (since it'll take some
time, a
Josh Berkus wrote:
>
> Tom, Bruce, Jan, etc.:
>
> As a PGSQL developer and business customer, I wanted to make some
> public requests as to the development path of PGSQL. While, obviously,
> you will develop the functionality *you* are interested in, I thought it
> might be valuable to
enacs.org and
arsdigita.com's web/db web bulletin boards, you'll find several hits.
-Roberto Mello
P.S: I know this doesn't directly anwser your question, but points you
to where to find the answer for yourself.
--
Computer ScienceUtah State Universit
les on the documentation. I'd be glad to finish
it up, add more things to it and then put it somewhere for review,
comments, suggestions, additions, etc.
Part of this document will be on how to port Oracle PL/SQL to
Postgres' PL/SQL and PL/Tcl.
- Roberto Mello
---
"Robert B. Easter" wrote:
> If someone has done it a better way, I'd like to hear how. However,
> sometimes it is possible to cache a count(*) value somewhere in the database
> so it doesn't have to be found everytime - it depends on your database and
> what the select is if you can store the co
Itai Zukerman wrote:
>
> Not sure if this is related, but under the non-threading Apache
> server, you get 1 persistent connection per Apache process. I don't
> think you can be sure which process gets the page with the connection
> request, so if you have a limit of, say, 50 processes, and your
"Poul L. Christiansen" wrote:
> > I was thinking of writing up a PHP script and put into crontab, which is
> > somehow easier than a shell script, but PHP is an apache module, so I
> > cannot execute PHP under crontab (it has to be executed in a browser
> > right?). I guess a shell script is nec
Jason wrote:
>
> aolserver is a web/application server. PHP is a server-side scripting
> language. Why exactly *should* it have a job scheduler?
>
> Some (such as myself) might also ask why should a web server have a job
> scheduler, but that's a thread for a different list :)
Because
Edmar Wiggers wrote:
>
> Is there any PostgreSQL developer working on the OpenACS (PG version of the
> ArsDigita Community Sytem) project?
>
> I have installed it and I am very much interested. There are a lot of small
> bugs though, mostly related to Oracle->Postgres migration, and some which
>
Jonathan Ellis wrote:
>
> I'm trying to find the correct function that returns the location of a
> substring within a string. Looking at
> http://www.postgresql.org/docs/user/x2731.htm, it gives the Function name as
> "textpos" but in the Example column it uses "position". But neither one
> wor
Tom Lane wrote:
>
> It kinda sounds like your wife created those tables in template1.
>
> Duplicating template1's contents into new databases isn't a bug,
> it's a feature ;-)
I've seen this behaviour too. Yesterday I pg_dumpall my 7.01 db
compiled from scratch and loaded in PG 7.02 ins
"Ross J. Reedstrom" wrote:
> > When I went into psql, I was some of my databases with all the pg_*
> > tables. Why? Also, if I dropdb the database and createdb it again, it's
> > as if I never deleted it. Is that normal/bug/feature? Why?
> >
>
> Ah, the Debian PostgreSQL package uses a dif
On Wed, Dec 13, 2000 at 10:55:03AM +0100, Bruno Boettcher wrote:
>
> despite this i still get sometimes the dreaded:
> Warning: 45 is not a valid PostgreSQL link resource in
> /home/bboett/www/fibu/includes/global.php on line 344
>Erreur durant la requete conn = Resource id #45
Pardo
On Wed, Dec 13, 2000 at 04:44:55PM -0800, Josh Berkus wrote:
> Mr. Daoust,
>
> You have reached the PostgreSQL SQL developers mailing list. We are
> not PostgreSQL sales people, and we have no marketing information to
> sell you. Please have a clue.
Errr... forgive me, but maybe
On Fri, Feb 02, 2001 at 04:37:34PM -0800, Josh Berkus wrote:
> Folks,
>
> 1. Has anyone had experience with trying to link Informix's 4GL as a
> procedural language extension for PostgreSQL? ANyone care to
> speculate? I happen to have access to a couple of former Informix
> employees ...
I finally came around to writing some extra documentation for PL/PgSQL
(and maybe PL/Tcl) and how to do PL/SQL-to-PL/PgSQL porting.
I downloaded the documentation sources, intending to use its nice
configure/make scheme but I can't find the configure script as described
in the curr
Hi,
What's the correct syntax to access rows in a FOR loop? I'm writing
a PL/PgSQL doc and seem to be making a mistake somewhere.
I am referring to this:
[<>]
FOR record | row IN select_clause LOOP
statements
END LOOP;
How do I access the
On Fri, Feb 16, 2001 at 09:41:09AM -0500, Steve Meynell wrote:
>
> I know this doesn't work but I need something like it.
> or something like
>
> select * from basket where max(date) and fruit='Apples';
> This would yield me:
> 15Apples July 20, 1999
Hi all,
I finished the beta version of my PL/SQL-to-PL/PgSQL-HOWTO last night
and put it in http://www.brasileiro.net/roberto/howto .
It explains basic differences between Oracle's PL/SQL and PG's
PL/PgSQL and how to port apps from one to the other. It also includes my
ins
meter that's a member of a table (e.g.
users.user_id%TYPE)?
- Can a parameter have a default value?
Thanks,
-Roberto Mello
P.S: I searched lots in the PG search engine, but couldn't find
anything.
--
Computer ScienceUtah S
on quotes on the PL/SQL-to-PL/pgSQL-HOWTO. It's called "Quote me
on that" and mentions several cases on quote usage in PL/pgSQL and what to
do about it.
http://www.brasileiro.net/roberto/howto
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux
Oh, did I mention that you get your own "PostgreSQL Powered" button
when you contribute a function/trigger? :)
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+
Roberto Mello - Computer Science, USU - http://www.br
t/postgres
Oh, did I mention that you get your own "PostgreSQL Powered" button
when you contribute a function/trigger? :)
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+
Roberto Mello - Computer Science, USU - http://www.br
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...
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
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:/
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
-
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!
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)
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
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
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
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 &
| 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 !
---
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
-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)
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
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@
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
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)-
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
-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
--
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
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
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
| 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."
--
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
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
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
| 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
+| 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.
---
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
--
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
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
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
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
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)-
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
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
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
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
-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
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
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
+ '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 |---
Table "blah"
Attribute | Type | Modifier
---+--+---
something | timestamp with time zone | default 'now'
name | character(50)
-Roberto
--
+| Roberto Mello - http://www.brasileiro.net |+
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)
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.
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.
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
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
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
---
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
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 |--
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
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?
-
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
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
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
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
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:
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
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)---
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
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
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
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
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
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
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
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
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)
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
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
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:
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
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
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
1 - 100 of 126 matches
Mail list logo
