[SQL] Re: [NOVICE] Knowing new item in table...

2001-08-03 Thread Jason Earl
--- macky <[EMAIL PROTECTED]> wrote: > im still in the dark when it comes to postgres. > is there a way i can > know if there was a new entry on a table... That's a pretty common problem. > scenario... > > i have a script that runs every 5 minutes... that > script checks if there's > a n

Re: [SQL] Feature Requests for 7.2 or 7.3 ...

2001-08-03 Thread clayton cottingham
Chris Ruprecht wrote: > > Hi guys, > > There are a number of features, I would love to see implemented in a future > release of PostGreSQL, more specific, into PL/PGSQL. Is there a central > place somewhere, where we (the PostGreSQL user community, I guess that is), > is able to see what is plan

Re: [SQL] where'd the spaces come from

2001-08-03 Thread Bruce Momjian
> Hi Bruce, > > a fix for what? > If you're meaning the leading space, then the fix is in the followup post > that I made to my original quiestion. i.e. > > psql -c "select to_char(12,'xFM000');" > to_char > - > x012 > (1 row) > > The 'FM' removes the space. So the FM is the correc

Re: [SQL] where'd the spaces come from

2001-08-03 Thread Richard Huxton
From: "Bruce Momjian" <[EMAIL PROTECTED]> > > Hi Bruce, > > > > a fix for what? > > If you're meaning the leading space, then the fix is in the followup post > > that I made to my original quiestion. i.e. > > > > psql -c "select to_char(12,'xFM000');" > > to_char > > - > > x012 > > (1 r

Re: [SQL] where'd the spaces come from

2001-08-03 Thread Gary Stainburn
Hi Bruce, a fix for what? If you're meaning the leading space, then the fix is in the followup post that I made to my original quiestion. i.e. psql -c "select to_char(12,'xFM000');" to_char - x012 (1 row) The 'FM' removes the space. Gary On Thursday 02 August 2001 4:50 pm, Bruce

Re: [SQL] converting timestamps to ints

2001-08-03 Thread Josh Berkus
Morgan, > I am writing an app that will need to do some calcs based on > differences > between when a record is first inserted and when it is last updated. > I have seen a lot of column::data-type in this list but can't find > the > relevant section in the documentation. Can anyone point me in