[GENERAL] Change UUID type default output representation

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 level.

[GENERAL] Coercing compound types to use generic ROW comparison operators

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 broa

Re: [GENERAL] Coercing compound types to use generic ROW comparison operators

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 rewr

[GENERAL] Defer a functional index calculation?

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

Re: [GENERAL] Defer a functional index calculation?

On Mon, Mar 23, 2009 at 4:46 AM, Sam Mason 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_

[GENERAL] Calculating a hash / fingerprint for a row / tuple

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 securit

[GENERAL] Row type select syntax - inconsistency or misunderstanding?

seem to play nice. It seems like I could do this with an exhaustive listing of columns in my 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 -

Re: [GENERAL] Row type select syntax - inconsistency or misunderstanding?

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 *, > >

[GENERAL] Dependency graph of all tuples relied upon in a query answer

forming the responses to a given query. How can I get 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

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

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")

Re: [GENERAL] Dependency graph of all tuples relied upon in a query answer

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 wou

Re: [GENERAL] Plperl functions with OUT parameters crashing each other when used in the same connection

postgres: http://www.oreillynet.com/pub/a/databases/2006/05/25/the-future-of-perl-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