Dennis Gearon wrote:
So, do you guys ever get together physically with a white board?
Your new to this aren't you? :) We are all over the world. We
collaborate via email, phone, instant messaging and IRC.
We do meet up at shows such as the upcoming OSCON and do birds of a
feather sessions etc..
Gah, I'm dreadfully sorry. The original functions were cut-and-pasted
from a "\df+" window, which meant they lost their quoted-ness, which
means if you try to cut and paste from my message to a SQL prompt,
you'll be sorely disappointed. Below are the edited versions.
create table rank_of_values
So, do you guys ever get together physically with a white board?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I hope this helps someone else ... I had struggled some time ago with
attempts to get a rank of values query to work, but then I gave up and
set it aside. I had another reason to attack it, and in between then and
now I learned how to return "setof" values from a function, as well as
how to con
Recently, I decided to rename one of my schemas from "adium" to "im".
Then, all inserts started failing.
I recreated a couple functions, changed the search path, and all inserts
are still failing due to referential integrity checks going against
"adium" still. Is there any way I can fix this, sh
Hello,
You could do it with a function in plPHP, plPython or plTCL fairly easily.
J
Hunter Hillegas wrote:
Is there any reasonable PGSQL query that could do something like this:
Find all the releases from the releases table. For each release, do what is
basically a find and replace on a column? Eac
Is there any reasonable PGSQL query that could do something like this:
Find all the releases from the releases table. For each release, do what is
basically a find and replace on a column? Each column contains slightly
different data and so the find and replace is not a constant. There needs to
be
Hello
I?m using this function to be executed within an after insert trigger, but
the part of code above wich is "painted" by blue gets in an endless loop.
I could use some help
Thanks in advance
Luis Agostinho
---,,---
CREATE FUNCTION fnc_copia_tbl_emitidos
John Sidney-Woollett wrote:
For what it's worth, we have a unicode 7.4.1 database which gives us the
sorting and searching behaviour that we expect (with the exception of
the upper and lower functions). We access the data via jdbc so we don't
have to deal with encoding issues per se as the drive
Dennis Gearon wrote:
John Sidney-Woollett wrote:
For what it's worth, we have a unicode 7.4.1 database which gives us
the sorting and searching behaviour that we expect (with the
exception of the upper and lower functions). We access the data via
jdbc so we don't have to deal with encoding issu
Richard Huxton wrote:
Dennis Gearon wrote:
If I've read everything right, in order to get:
multiple languages on a site
with the functionality of ALL of:
REGEX
LIKE
Correctly sorted text
A site would have to:
create a cluster for every language needed
run a separate data
All of the ISO 8xxx encodings and LATINX encodings can handle two langauges, English and at least one other. Sometimes they can handle several langauges besides English, and are actually designed to handle a family of langauges.
The ONLY encodings that can handle a significant amount of multiple
Mike Nolan wrote:
Here are two queries (under 7.4.1):
'mytime' is a timestamp field that is indexed.
select * from mytable where mytime > '2004-06-21'
select * from mytable where mytime > current_date-3
Looking at an explain on these queries, the first one will use the
index and the second one will
Here are two queries (under 7.4.1):
'mytime' is a timestamp field that is indexed.
select * from mytable where mytime > '2004-06-21'
select * from mytable where mytime > current_date-3
Looking at an explain on these queries, the first one will use the
index and the second one will not, even tho
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I've built PostgreSQL 7.4.3 RPMS on RHEL3. Needed to change the spec file
a bit for tcl and kerberos. They heve been tested and are working fine.
RPMS, SRPMS and SPEC file is located at:
http://www.gunduz.org/postgresql/packages-7.4.3/rhel3/
> On Wed, 23 Jun 2004, Dennis Gearon wrote:
>
> > This is what has to be eventually done:(as sybase, and probably others do it)
> >
> > http://www.ianywhere.com/whitepapers/unicode.html
>
> Actually, what probably has to be eventually done is what's in the SQL
> spec.
>
> Which is AFAICS bas
Tom,
I have solved the problem. I don't know exactly what I did, but I think it had
something to do with a screwed up "template1". When I first tried to load the
database, I connected to template1 instead of the database I wanted to load. Things
went down hill from there. So I finally just
On Jun 24, 2004, at 9:50 AM, Campano, Troy wrote:
Hello,
Is PostgreSQL’s optimizer cost based or syntactical based?
cost based
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 5: Hav
Richard Huxton <[EMAIL PROTECTED]> writes:
> You'd need a separate database, not a separate cluster. Each database
> can then have their own encoding and locale.
Not so, unfortunately. You get one locale per cluster, at least for
LC_COLLATE and LC_CTYPE which are the significant settings for thi
Title: PostgreSQL Optimizer
Hello,
Is PostgreSQL’s optimizer cost based or syntactical based?
Thank you!
On Wed, 23 Jun 2004, Dennis Gearon wrote:
> This is what has to be eventually done:(as sybase, and probably others do it)
>
> http://www.ianywhere.com/whitepapers/unicode.html
Actually, what probably has to be eventually done is what's in the SQL
spec.
Which is AFAICS basically:
Allow mu
Dann Corbit wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Richard Huxton
LuisH wrote:
Question about Performance:
What about access sounds (WAV or VOX) from filesystem or from Blob
Database Whish performance can I expect on ea
22 matches
Mail list logo
