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 bac
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:
p
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 Rhei
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 th
"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 o
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-200
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.
rega
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
> t
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 i
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...
---(e
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
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
-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 abou
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 cont
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:
> >
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
proble
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 o
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 D
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 Lane mentions using the execute command see(http://archives.postgresql.org/pgsql-general/2001-03/msg01614.php).
Since I have no interest in picking up yet another language, I tried this:
qry := ''se
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 o
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
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 regardin
29 matches
Mail list logo
