On Tue, Feb 22, 2011 at 12:26:41PM -0800, John Fabiani wrote:
> Hi,
> I would have thought that there would be a simple built-in function that
> would
> escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not see
> anything?
>
> I am I wrong?
>
> Johnf
>
The manual goes over many
On Mon, Jan 31, 2011 at 10:50:43AM -0500, Emi Lu wrote:
> Good morning,
>
> Is there an existing method to get days between two dates?
>
> For example,
>
> select '2010-01-01'::date - '1999-10-12'::date
>
> Returns how many days.
>
> Thank you,
>
> --
> Lu Ying
>
Didn't you just answer your own qu
On Wed, Jan 19, 2011 at 08:17:50AM -0500, Stephen Belcher wrote:
> Another way to match multiple occurrences is to use curly brackets with a
> number, like:
> select 'ab' ~ '^[a-z]{2}$';
>
> It can be done with a range of numbers as well:
> select 'ab' ~ '^[a-z]{2,4}$';
> select 'abab' ~ '^[a-z]{2
What does a 'timestamp || numeric' actually look like? It
means the timestamp written out a.k.a text and the same for
numeric. The database does not know that that is what you
wanted without the casts to text.
Cheers,
Ken
On Tue, Dec 07, 2010 at 04:47:46PM -0500, Tony Capobianco wrote:
> Ok, that
You can use a hash index for this. It's drawback is that it is not
yet WAL enabled and if your DB crashes you will need to rebuild the
index to fix the corruption. It works well(only) with equality
searches. If it is a scenario where you must have WAL, use a
function index based on the hash of the
On Thu, Nov 04, 2010 at 08:42:21PM +0100, Pavel Stehule wrote:
> 2010/11/4 Dean Gibson (DB Administrator) :
> > I'm sure this has been asked before, but I couldn't find it:
> >
> > I have a "zzz CHAR (8)" field.?? It needs to be CHAR because trailing spaces
> > need to be ignored for most operation
On Thu, Sep 30, 2010 at 10:30:16PM +0400, Dmitriy Igrishin wrote:
> Hey Kenneth,
>
> Thank you for solution. But sorry, personally, I don't clearly
> understand the benefits of this code compared with using
> simple array literals or even array constructors...
> Conversion "overheads" from text? D
Hi Steve,
I am going to follow-up to this post so that the results will
be available to other PostgreSQL users. Here is a simple
example program for binary transmission of an int8 array
using native libpq functions and not the libpqtypes:
---native_binarray_dspam.c--
/*
*
9.0 allows you to defer unique constraints.
Ken
On Thu, Sep 23, 2010 at 10:18:39AM -0700, Ozer, Pam wrote:
> Is it possible to disable a unique index? I have a process that's
> running that inserts duplicate records into a table and then does a
> cleanup afterwards. I know that I can drop the i
On Wed, Aug 04, 2010 at 10:22:12AM -0400, Joshua Gooding wrote:
> I am using Postgres 8.4 with 10 partition tables. We'll call them
> reports_00 through reports_09.
>
> I have a field that is a BIGINT which is a 13 digit number that is the
> epoch time, which is the constraint that the table is
On Wed, Aug 04, 2010 at 07:20:31AM -0400, Frank Bax wrote:
> John Hasler wrote:
>> How does PostgreSQL react to time being stepped at bootup? My Chrony
>> NTP package might cause it to do so on rare occasions when the hardware
>> clock is way off. This would only happen during bootup.
>
>
> My nt
On Wed, Jul 21, 2010 at 05:49:53PM +0530, Trinath Somanchi wrote:
> Hi All,
>
> I have a column in my Postgresql database tables which need UUID.
>
> Is there any function in Pgsql for UUID generation. Please help me in this
> regard.
>
> --
> Regards,
>
On Fri, Jun 18, 2010 at 04:24:18PM -0600, Steven Dahlin wrote:
> I have been trying to figure out how I can run a pgsql script like I can run
> a plsql script with oracle's sqlplus. Here is a sample script file for what
> I want to run:
>
> declare
> sysuserid integer := 0;
> hwcustid intege
On Fri, Jun 11, 2010 at 04:39:37PM +0200, Thomas Kellerer wrote:
> John, 11.06.2010 16:17:
>> Hi,
>> I'd like to learn the use of window functions and did not find a tutorial
>> using google ("postgres window function tutorial"). I'm hoping someone
>> has a
>> link.
>
> There is one in the manual
On Wed, May 19, 2010 at 12:26:07PM +0400, silly sad wrote:
> On 05/18/10 23:27, Kenneth Marshall wrote:
>
>> It works using 'now' and I assume that since curtime is
>
> now() is NOT the CURRENT timestamp in fact,
> it is about the timestamp of the current transact
Okay, this works as well. Thank you for all of the
assistance.
Regards,
Ken
On Tue, May 18, 2010 at 09:25:00PM +0200, Pavel Stehule wrote:
> 2010/5/18 Richard Broersma :
> > On Tue, May 18, 2010 at 12:08 PM, Kenneth Marshall wrote:
> >
> >> http://www.postgresql.org/d
To follow-up,
It works using 'now' and I assume that since curtime is
of type DATE that the assignment casts the return automatically
to type DATE. Thank you for the ideas.
Regards,
Ken
On Tue, May 18, 2010 at 12:12:46PM -0700, Richard Broersma wrote:
> On Tue, May 18, 2010 at 12:0
I am trying to write a function that updates the
date column to the current date. According to:
http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
you can use CURRENT_DATE. When I try to use it in
the following pl/pgSQL function it gives the error:
ERROR
On Thu, Apr 29, 2010 at 01:13:40PM -, sandeep prakash dhumale wrote:
> Hello All,
>
> I am trying to get tsearch working for my application but I am facing a
> problem when alphabet 'Y' is the in the tsquery.
>
> can anyone please share some light on it.
>
>
> # SELECT 'hollywood'::tsvector
On Thu, Sep 17, 2009 at 06:34:39PM +0100, Gavin McCullagh wrote:
> On Thu, 17 Sep 2009, Gavin McCullagh wrote:
>
> > On Thu, 17 Sep 2009, Frank Bax wrote:
> >
> > > Gavin McCullagh wrote:
> > >> SELECT time, to_timestamp(time) AS ts,
> > >> EXTRACT('months',to_timestamp(time)) FROM mdl_log;
> >
On Thu, Sep 17, 2009 at 07:47:13AM -0700, rawi wrote:
>
>
> Leo Mannhart wrote:
> >
> > Caveat: If you use the standard sequence generator in hibernate, it is
> > not using the postgres-sequence in the "usual" manner. hibernate itself
> > caches 50 ID's as sequence numbers by default. This means
21 matches
Mail list logo
