Listmail wrote:
On Sun, 29 Apr 2007 22:33:37 +0200, Rich Shepard
<[EMAIL PROTECTED]> wrote:
On Sun, 29 Apr 2007, Martijn van Oosterhout wrote:
Then I'm afraid you havn't indicated your requirements properly. All
I can
see is that the interval type does exactly what you want. It can store
found it at : http://ftp.gnu.mirrors.hoobly.com/gnu/non-gnu/ispell/
chrisj wrote:
>
> Hi, the tsearch2 intro has instructions for creating a US_en locale, here
> is a snippet:
>
> .. it can be created from the /languages/english directory with the
> following command:
>
>sort -u -t/
On Sun, 29 Apr 2007 22:33:37 +0200, Rich Shepard
<[EMAIL PROTECTED]> wrote:
On Sun, 29 Apr 2007, Martijn van Oosterhout wrote:
Then I'm afraid you havn't indicated your requirements properly. All I
can
see is that the interval type does exactly what you want. It can store
days, weeks, mont
On Sun, 29 Apr 2007, Rich Shepard wrote:
How does one define 'shift' with intervals? 0.33 DAY?
On further reflection, I understand how to make the interval 'day' work by
comparing the current timestamp with the month and hour. If there's no
record within the necessary range, a message is e-
On Sun, 29 Apr 2007, Martijn van Oosterhout wrote:
Then I'm afraid you havn't indicated your requirements properly. All I can
see is that the interval type does exactly what you want. It can store
days, weeks, months or any combination thereof. You can multiply them and
add them to dates and all
On Sun, Apr 29, 2007 at 07:43:52AM -0700, Rich Shepard wrote:
> Alexander's reference to the internal postgres interval support as different
> from the SQL standard INTERVAL. If so, it's my mis-writing.
>
> Regulatory requirements are that monitoring is to be done 'once per
> shift,' 'daily,' 'w
On Sun, 29 Apr 2007, Alexander Staubo wrote:
We could be talking about different things, though. What Joe Celko is
probably talking about is referential integrity as defined in a schema
using foreign keys, as opposed to, say, triggers. Eg.,
Alexander,
I think you are correct. So much of his
On 4/29/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
Thank you. I never before was aware of DRI, but Joe Celko mentions it
several times in his book, "SQL Programming Style." I searched with Google
and found a couple of hits that were postgres specific so I went looking in
the docs to learn wha
On Sun, 29 Apr 2007, Tom Lane wrote:
What gives you the idea that type INTERVAL is Postgres-specific? It's in
the SQL standard.
Tom,
I know that and that was not to what I referred. Perhaps I mis-understood
Alexander's reference to the internal postgres interval support as different
from th
On Sun, 29 Apr 2007, Tom Lane wrote:
Um, what are you trying to do that's different from declaring a column of
the table as being of type Permit_Type?
Tom,
Nothing. After further consideration I decided that the domain was
unnecessary and the table column with a CHECK() constraint the more
On Sun, 29 Apr 2007, Alexander Staubo wrote:
The closest counterpart to MS SQL Server's DRI is the "references"
permission:
http://www.postgresql.org/docs/8.2/interactive/sql-grant.html
Alexander,
Thank you. I never before was aware of DRI, but Joe Celko mentions it
several times in his bo
11 matches
Mail list logo
