I have been using UUIDs for PKs to allow me the flexibility of
generating PKs within PostgreSQL or at the application code level.
However, I have been storing them as CHAR(32) in the hex string
representation (no dashes) in order to simplify comparisons and
manipulations at a very practical
On Mon, Mar 23, 2009 at 4:46 AM, Sam Mason s...@samason.me.uk wrote:
On Fri, Mar 20, 2009 at 05:37:33PM -0700, Randall Lucas wrote:
I added a functional index.
create table example (id serial primary key, stuff text, parent_id
int);
create index example_root_idx on example
Hi folks,
I am holding hierarchical data in a table and often need to calculate the
root of a hierarchy. Initially, a recursive plpgsql function worked just
fine. But performance started to lag when I got to scale.
So, I added a functional index.
create table example (id serial primary key,
On Thu, Oct 11, 2007 at 02:52:08PM -0400, Tom Lane wrote:
Randall Lucas [EMAIL PROTECTED] writes:
Is there a way I can convince my custom composite data type (point_pk)
to use the row-wise comparison functions, so that I don't have to
hackishly rewrite the comparison algorithm for each
type (point_pk)
to use the row-wise comparison functions, so that I don't have to
hackishly rewrite the comparison algorithm for each composite type?
Using 8.1.5.
Thanks,
Randall
--
Randall Lucas Tercent, Inc. DF93EAD1
---(end of broadcast
-in-postgresql.html
Best,
Randall
--
Randall Lucas Tercent, Inc. DF93EAD1
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Fri, Sep 01, 2006 at 09:30:57AM -0400, Merlin Moncure wrote:
On 8/31/06, Randall Lucas [EMAIL PROTECTED] wrote:
Now that I have this query, in order to make my case, I need to sign
off on all of the individual data that went into it. I would like to
do something like:
select
On Thu, Aug 31, 2006 at 09:17:54AM -0400, Merlin Moncure wrote:
On 8/30/06, Randall Lucas [EMAIL PROTECTED] wrote:
An inverted way of thinking about the problem is the notion of getting a
source document (say, a company registration form) and parsing and
storing it in a normalized format
this information? Or am I off the deep end (-ency
graph) with this one?
Best,
Randall
--
Randall Lucas Tercent, Inc. DF93EAD1
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
audited
table, but that seems kludgey.
Any thoughts on either the unrow function workaround or my end goal?
Best,
Randall
--
Randall Lucas Tercent, Inc. DF93EAD1
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, Aug 23, 2006 at 02:31:35PM -0400, Tom Lane wrote:
Randall Lucas [EMAIL PROTECTED] writes:
In trying to retrieve a row as a composite rowtype from a table, I'm running
into what appears to be an inconsistent result based on whether I select *,
table.*, or the list of columns
I'm looking for a way to calculate a hashcode or fingerprint for a row /
tuple of arbitrary width. The goal is to be able to store, in an audit
table, a fingerprint which could be compared against a later fingerprint
to detect changes (this application does not call for cryptographic
level
12 matches
Mail list logo