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
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
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
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
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
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
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
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
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
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
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
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 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:
> >
Hi,
Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings?
Alex
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
-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
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
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
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
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
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
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
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
"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
"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
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
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
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
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
29 matches
Mail list logo
