Couldn't agree more - syntax like
SHOW TABLES;
is inituitive and somehow right - [chuckles] - Mysql does not have
*everything* wrong!
regards
Mark
Bruce Momjian wrote:
I like the idea of adding a new syntax to show that information using
simple SQL command syntax, and putting it in the
El Sáb 03 Ene 2004 18:20, ivan escribió:
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
Look deeper into what Christopher said and use casting to get the right
output:
On Thu, Jan 01, 2004 at 01:59:45PM +0800, William ZHANG wrote:
in preproc.y:2021:
...
Thanks for the report. I just fixed it in HEAD and 7.4.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [EMAIL PROTECTED]
Go SF 49ers! Go Rhein
Hi,
I was wondering is there or will there be support for remote procedures/functions in Postgresql? Not only server to server, but database to database? Such as calling a function in DB "B" from DB "A" or Server Gaia DB "B"from Server Zeus DB "A"?
Alex
Thomas Hallgren [EMAIL PROTECTED] writes:
I'm working on a pljava module. In it, I'd like to cache some allocated
structures (allocated using TopMemoryContext) using a string as the key. I
need a hash or binary-search table with dynamic size where I can store
arbitrary structures and then find
Simon Riggs [EMAIL PROTECTED] writes:
Select count(*) could be evaluated against any available index
sub-tables, since all that is required is to count the rows. That would
be significantly faster than a full file scan and accurate too.
PostgreSQL stores MVCC information in heap tuples only,
Joe Conway said:
Andrew Dunstan wrote:
AFAIK it is not available except for $$$. It looks like the relevant
standards are parts 1 and 2 of the SQLJ standard (Part 0 covers
embedded SQL).
For working drafts try:
http://www.wiscorp.com/sql/sql_2003_standard.zip
(5WD-13-JRT-2003-09.pdf)
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba= select now()::timestamp(0);
There's also current_timestamp(0), which is a more standards-compliant
way of doing the same thing.
regards,
Mark Feit wrote:
Peter Eisentraut declared that from that point on, stdin would be
whatever stream the \copy command came from. I'd like to propose a
variant on the FROM clause which makes good on Peter's declaration
without breaking anything already using FROM STDIN and expecting it
to
Tom Lane wrote:
(It might be good if we had a more standardized way of generating
HISTORY though. I tried a couple different versions of lynx and
got a couple different outputs, none perfectly matching whatever
version Bruce is using ...)
There lies the problem. Making these text files is
Oliver Elphick wrote:
I can't very easily get cvs tip built on linus-hppa, because I
couldn't make a package of that except for experimental, but
experimental doesn't get processed by the autobuilders.
Time to break out the old configure; make; make install...
---(end
Bruce Momjian wrote:
I am starting to agree that our \d* handling is just too overloaded.
Look at the option list from \?:
Can anyone remember all those?
Yes.
I like the idea of adding a new syntax to show that information using
simple SQL command syntax, and putting it in the backend so
On Sat, Jan 03, 2004 at 08:25:21PM -0500, Bruce Momjian wrote:
I finally figure it out, I just end up forgetting again later. I still
have no clue how I'd find the same data without using psql. In MySQL
I can run those queries from PHP, PERL...etc. I know you can find that
data in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Someone mentioned in passing something on general:
To this day, I have trouble with that in PostgreSQL.
I'm constantly doing:
psql help;
ERROR: syntax error at or near help at character 1
I seem to recall some past discussion about
A E wrote:
Hi,
I was wondering is there or will there be support for remote
procedures/functions in Postgresql? Not only server to server, but
database to database? Such as calling a function in DB B from DB A
or Server Gaia DB B from Server Zeus DB A?
You could use dblink from contrib.
Hi,
Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings?
Alex
i know, but i talking about default time output, it would be for
time, date and date with time, not formating all the time.
On Sun, 4 Jan 2004, Tom Lane wrote:
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba=
I'm working on a pl/java project and have come quite far with it. Triggers
and Functions are both callable, there's support for complex types etc. I
have a project on GBorg (pljava) where I'll post all source in a CVS
repository in a matter of days (the code is ready but my ISP have a router
I think much of the issues should be resolved using JDBC and
java.sql.ResultSet and a couple of interfaces that can be used when mapping
specific types to specific Java objects (SQLData, SQLReader/SQLWriter).
A PL/Java needs a hook where a connection is initialized for JDBC access
in the backend.
Was wondering if there was anything akin to an evaluate statement in
Postgresql for dynamic strings?
By dint of tricky programming you can a function that can generate and
execute arbitrary strings. I believe there's even an example of this in
the docs.
Chris
---(end
Try the contrib/dblink module.
Chris
A E wrote:
Hi,
I was wondering is there or will there be support for remote
procedures/functions in Postgresql? Not only server to server, but
database to database? Such as calling a function in DB B from DB A
or Server Gaia DB B from Server Zeus DB A?
Peter Eisentraut writes:
[Patch to make psql's \copy read from the current input, not just
the standard input or a file.]
I'm not sure about the proposed syntax, but the feature sounds quite
reasonable.
I have a patch written for this that uses the - syntax:
\copy junk
Thanks. I searched for it and I found something. It tells me to use the perl module. But Tom Lanementions using the execute command see(http://archives.postgresql.org/pgsql-general/2001-03/msg01614.php).
Since I have no interest inpickingup yet anotherlanguage,I tried this:
qry := ''select *
Quoting Tom Lane [EMAIL PROTECTED]:
Martin Marques [EMAIL PROTECTED] writes:
Look deeper into what Christopher said and use casting to get the right
output:
prueba= select now()::timestamp(0);
There's also current_timestamp(0), which is a more standards-compliant
way of doing the same
A E [EMAIL PROTECTED] writes:
I tried to execute a dynamic sql string using the dynamic record
column name but I getting this error: ERROR: syntax error at or near
into at character 8. Does the execute statement not allow the into
keyword
It does not :-(. The best way of getting data back
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
Chris
---(end of broadcast)---
TIP 8: explain analyze is your friend
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
Yeah. If you have a problem with that, it's grounds for a bug report.
Note though that GiST can't handle
Michael Glaesemann wrote:
On Dec 29, 2003, at 11:28 AM, Sai Hertz And Control Systems wrote:
I would like to share my concerns about the IEEE 754 specification and
floating point handling by PostgreSQL .
What specifically are your concerns regarding floating point handling
and
On Jan 4, 2004, at 6:51 PM, Bruce Momjian wrote:
Michael Glaesemann wrote:
On Dec 29, 2003, at 11:28 AM, Sai Hertz And Control Systems wrote:
I would like to share my concerns about the IEEE 754 specification
and
floating point handling by PostgreSQL .
What specifically are your concerns
29 matches
Mail list logo