Dear friends,
I have this table
table work{
day date,
hour integer,
}
select * from work;
date | text
---
1-1-20031
1-1-20031
2-1-20035
3-1-200310
5-1-200315
how can i obtain this?
date |text
---
1-1-20032
2-1-20035
3-1-2003
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 -
you have a
time frame for the release of 7.1b? Any additional comments on 7.1
features,drawbacks, caveats, etc, are appreciated.
Thanks,
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Soft
s/procedures.
Thanks for the great work PG team.
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto
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
---
set rowcount [ns_pg ntuples]
in my Tcl code and there it is. The driver is available at either
http://www.aolserver.com or http://www.openacs.org (the latter has a
more elaborate version of the driver).
-Roberto
--
Computer ScienceUtah State
ty.com (with mere 32 K hits per
second).
AOLserver also has a built-in database abstraction layer and Tcl
interpreter (with the option of caching compiled code of scripts), and a
comprehensive API for building massively scalable dynamic websites.
More info at http://www.
AOL) has had such facility (and many many others for
db-backed websites) since 1995. ns_schedule_proc.
http://www.aolserver.com
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software &
ad for a different list :)
Because PHP is supposed to solve web development problems. And this is
one of them. It's very useful.
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux
lipped, and they're not found
unless someone really uses the module, finds and reports them.
OpenACS 4 is what we are actively working on right now. It's a much
better piece of software than the 3.x series, but it does not have all
the modules that 3.x series does, but we
s "position". But neither one
> works!
>
> bf2=# select position('high', 'ig');
> ERROR: parser: parse error at or near ","
You need SELECT position('ig' in 'high');
lbn=# select position('ig' in 'high
r deleted it. Is that normal/bug/feature? Why?
-Roberto
P.S: It's nice to see some Brazilians on the list :) I am from Brazil
too. I hope Conectiva is promoting PostgreSQL down there.
--
Computer ScienceUtah State University
Space Dynamics Laboratory
ches your username.
Bit I did specify my database name.
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto
Resource id #45
Pardon me,
bout wouldn't this be more appropriate on a PHP list?
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu
e me, but maybe we could be help the PostgreSQL team by
kindly directing people to their corporate website, so they can purchase
services that are going to fund the project.
As long as the project is happy I am happy.
Just some thoughts.
-Roberto
--
C
IQUE INDEX test_index ON test (lower(username));
ERROR: DefineIndex: function 'lower(varchar)' does not exist
The same happens using upper, initcap,...
Thanks
Roberto Bertolusso
xample.
http://www.postgresql.org/devel-corner/docs/
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto
n the current docs. Where can I find it?
I know I can just use the Makefiles with a little tweaking, but I am
wondering if I am missing something here.
Thanks,
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory
do I access the rows within the for loop? row.field?
Thanks,
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free Software & GNU/Linux Club http://fslc.usu.edu
My home page - http:
-
2 | Apple | 2000-12-05 00:00:00-07
(1 row)
Look at the documentation for the ORDER BY and LIMIT clauses on the PG
docs.
-Roberto
--
Computer ScienceUtah State University
Space Dynamics Laboratory Web Developer
USU Free So
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 i
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
-
On Mon, Apr 09, 2001 at 07:22:52PM -0400, Wei Weng wrote:
> And I want to get the names of the largest 10 "id"s. How can I do that in
> sql?
What do you mean by "largest"? Largest id? "largest" text string? If
it's the id you can do:
Hi,
How can I do timezone conversions in PG? I looked on the docs and
couldn't find how. I want to find the current time in another timezone.
Thanks,
-Roberto
P.S: This type of function would be excellent on the cookbook
(www.brasileiro.net).
--
+|
l
> of time for which the two datetime ranges overlap.
>
> Roberto, please include this in your online PL/pgSQL function library.
Done! Thanks Josh! Date/Time manipulation functions are now our most
popular category.
How about you? Do you have a (SQL|PL/pgSQL|
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 &
use a howto or
Bernardo,
Do you really need the keys to be random numbers? Can't the keys be
sequential numbers, like 1,2,3,4...? That'd be a lot easier to make
unique, and as far as the user is concerned, it'll be random for him/her.
-Roberto
--
+
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
e then.
>
> Do anyone know where the 7.1 RPM's are so that I can install them?
Have you tried postgresql.org? I am sure you can find it there :) It
looks like it's bogged down with downloads now. You can get it from our
mirror at http://fslc.usu.edu/downloads/pub
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
tch (1994) so I hope this won't be much of an issue (but
then PHP 4 still has threading problems AFAIK).
Not using persistant connections is just too slow for me. It's
instantaneous for AOLserver to generate a page, when the same page with the
connection overhead in PHP takes A L
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
;s to
answer your questions that we take the time to write docs in the first
place :)
Short answer: everything in your function is executed in one
transaction. BEGIN and END in PL/pgSQL are NOT the same as in the
transaction semantics.
-Roberto
--
+| http://fsl
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
t be able to do it with subqueries. PostgreSQL 7.1 has
subqueries in the FROM clause as well al regular sebqueries.
Read the subqueries chapter of Bruce Momjian's PostgreSQL
book for more info, or give us more information. The book is at
http://www.ca.postgresql.org/docs/awbook.html
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
On Tue, May 08, 2001 at 09:16:56PM -0400, Wei Weng wrote:
> I have a table that has a serial for primary key. Is it possible to get
> the new available primary key right after I insert a row of new entry?
Yeah. Se the documentation on triggers.
-Roberto
--
+
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
I couldn't find the documentation for dealing with Large Objects on
the documentation. Any pointers?
The only info I found on Large Objects was on the programming guide,
but I'm not looking to write C functions with largo objects.
Thanks,
-Roberto
--
+
ter PGAccess
> editing are met with: 'Parse error at or near ""'
IIRC, pgaccess does quote-escaping for you, so if you try to write
"standard" PL/pgSQL (escaping single quotes), it'll barf this error.
Just something to check.
-Roberto
--
On Wed, May 30, 2001 at 11:14:38PM +0530, Sharmad Naik wrote:
> hi,
> I wanted to know that does postgresql database support php-nuke
This is a php-nuke question. Head to their website and it should be
stated there somewhere.
-Roberto
--
+| http://fslc.usu.e
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
om trigger. It is
> possible to do this without triggers?
A little RTFM'ing wouldn't hurt.
Currently you can't return tuples from "regular" PL/pgSQL functions.
It heard this functionality will make it in 7.2.
-Roberto
--
+| http://fs
there anything we can do about this? It seems tailor-made for a
> PostgreSQL app ... I volunteer for design/SQL if someone can find a PHP
> or Java coder for the interface.
I think this has already been done, but I don't know if it has been
linked from the man pg.org site. It's
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
ange. Is there an easier way?
pgAcess should make it easier. It lets you look at the definition and
lets you modify/drop/recreate it.
If you're on windows, you might want to look a pgAdmin (available at
greatbridge.org).
-Roberto
--
+| http://fslc.usu.edu USU
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
SQL:
>
> SELECT date_part('day', date), count(*)
> FROM client_order WHERE (date >= '01/05/01' AND date < '01/06/01') AND
> status = 'Processing'
> GROUP BY date_part('day', date);
Didn't look very hard,
On Tue, Jul 03, 2001 at 11:07:35AM -0500, Manika Dey wrote:
>
> Hi,
> Is postgresql database available for WindowsNT platform.
Yes. Download CygWin at http://www.cygwin.com and read the
documentation in postgresql.org regarding installation on Windows.
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
On Wed, Aug 01, 2001 at 09:28:39AM +0100, Richard Huxton wrote:
> Hi Roberto - long time no see.
Hey Richard. Yeah. Summer classes and summer jobs :-) I have to finish
my expanded "Porting From Oracle" thingy.
>
> richardh=> select '1970-01-01'::date
You can have psql output its internal queries and that will give you
some insight:
roberto@brasileiro:~/documents/pictures$ psql -e foobar
Welcome to psql, the PostgreSQL interactive terminal.
...
foobar=# \d blah
* QUERY *
SELECT relhasindex, relkind, relchecks, reltriggers,
On Mon, Oct 22, 2001 at 05:14:32PM +0800, guard wrote:
> dear all
>
> IF update table set field='c:\windows'
> but
>
> c:\windows -> c:windows
Errr. Some context please? My crystal ball is still getting fixed :)
-Roberto
--
+| http://fslc.usu.edu USU
ass
Unless it's some OO extension in PostgreSQL that I don't know about, I
have never heard of the type "repertory" and "name". I don't think you
can use your table name as a data type.
BTW, you should also stay away from arrays (IMHO), since they ar
As the documentation for PL/pgSQL clearly states with several examples,
you have to double the quotes in strings>
INSERT INTO rtest(xz,yz,xy)
VALUES (''(0,2), (1,3)'',
''(1,2), (2,3)'',
''(0,1), (1,2)'');
I don't
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
On Mon, Jul 01, 2002 at 02:29:27PM +0300, Oleg Bartunov wrote:
>
> I tried 1.2.4 but didn't found how to configure tora to work
> with postgresql.
Tora is very nice. I'm using 1.3.5 with PG 7.2 (Debian). I had to compile
the PostgreSQL Qt 3 module for it to work.
-Rober
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
eresting, more useful, more
feature-complete (as far as Relational database servers go), more fun and
what you could learn with PostgreSQL you could take to other database
servers who are out to be real database servers, not the case with MySQL.
AFAIK, MySQL is more common.
-Roberto
--
+| ht
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
likely there are much more variables rather than PGDATA,
> PGHOST and PGPORT.
> Where can I find them?
Perhaps you're looking for
http://www.postgresql.org/idocs/index.php?runtime-config.html
Please trim your replies to the list.
-Roberto
--
+| http://fslc.usu.e
On Mon, Jul 29, 2002 at 08:57:12AM -0300, Elielson Fontanezi wrote:
> Bom dia Roberto!
Bom Dia! :-)
> I have just read these documents.
> The variables listed in the link below, say about variable that I
> cannot
> set from a .profile file.
> By the way, if I
the code originated in
> Postgres. It is even more free than MySQL.
It should be mentioned that PostgreSQL has great community support.
If you require commercial support, that is provided by several companies,
including Pgsql Inc., Red Hat, Aglio, etc.
-Roberto
--
+| http://fslc.usu.edu/ USU F
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
LSE 'void') as order_state
FROM events_registrations
GROUP BY order_id ) o_states
WHERE o_states.order_id = o.order_id;
Oracle 9 does support SQL92-compliant CASE WHEN. It's much more clear than
using cryptic decode to me.
See http://www.postgresql.org/idocs/inde
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
rocedure for working with i18n'd characters described in the
documentation? I'm looking for something that mentions the specifics of
locale interaction and all that.
I ask because the sort of question Tim asked is a recurrent one in a
portuguese PostgreSQL mailing list I subscribe
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
1 - 100 of 139 matches
Mail list logo
