hi
when i do
select current_date;
around midnight, when does the date switch? does it switch according
local time zone, or does it switch by GMT ? i did not find docs
about this near the docs of "current_date" or anywhere else.
please do add it to the documentation.
thanks for good work!
eri
"cristi" <[EMAIL PROTECTED]> writes:
> FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289, up=
> per =3D
> 1, special =3D 60672
> Why do I have this error message and how can I fix it?
This is a data-corruption problem. Have you had any system crashes or
other odd behavior l
(B
(B
(BOoops! I fixed it. Somewhere along the
(Bline the name of the trigger had changed, and there was an old, probably
(Binvalidated trigger left on the table. Once I dropped that it was
(BOK.
(B
(BSorry for the inconvenience!
(B
(BRegards
(BIain
(B
(B - Original Message
(B
(B
(BHi All,
(B
(BI have a problem with a before update
(Btrigger that I was wondering if someone might be able to give me some help
(Bwith.
(B
(BDB version is 7.2. Here is a cut down
(Bversion of an already simple trigger and function that is returning the
(Berror:
(B
(B
On Fri, 14 Nov 2003, Jim Drummey wrote:
> Hello-
>
> The 7.2 version distributed with RedHat 8.0 seems not
> to work for substrings and POSIX regular expressions.
>
> I think this should work
>
> pds=> select substring( str1 from ',' ) from address;
> ERROR: pg_atoi: error in ",": can't pars
Hello-
The 7.2 version distributed with RedHat 8.0 seems not
to work for substrings and POSIX regular expressions.
I think this should work
pds=> select substring( str1 from ',' ) from address;
ERROR: pg_atoi: error in ",": can't parse ","
Am I missing something?
TIA
J. Drummey
[EMAIL PR
Apologies as this probably isn't really for this list but...
In postgresql you can execute a statement such as:
SELECT 1 > 2;
And it would return 'f'
Does anyone know if you can do this in SQL Server as I have to do a
conversion of some prewritten SQL code.
MTIA,
Graham.
Guillaume,
Thank you very much for your response.
Yasir
On Sat, 15 Nov 2003, Guillaume LELARGE wrote:
> Date: Sat, 15 Nov 2003 17:41:41 +
> From: Guillaume LELARGE <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: [SQL] Getting last insert value
>
> Le Samedi 15 Novembre 2003 16:40,
Hy, I have a table containing some rows. Each row contains a field name
which is of type String.
For example:
in row1 string1 is "Adieu Poulet",
in row2 string2 is "Adieu a Poulet",
in row3 string3 is "Adiue Poulet",
in row4 string4 is "Adieu Pouleet", etc..
(That is each string resembles each oth
Nick Fankhauser wrote:
Hi-
I'm suffering from a performance problem, but when I look at my query, I'm
not convinced that there isn't a better way to handle this in SQL. -So I'm
seeking advice here before I go to the performance list.
I have three tables- case, actor and actor_case_assignment.
As
Hello,
Is there a way to do addition and subtraction on BIT types? For example,
for
creat table test (a BIT(3));
insert into test values (B'101');
select a + 1 from test; fails
and select a::smallint + 1 from test; also fails.
In addition, is there a way to change the bit of a bit string? For
[sNip]
> It's the same in this case. The tree building stuff only ever looks down
> so the level returned in the query results will start at 1 no matter
> where you enter your tree. In our case we could enter the tree at
> 'node' 100 and get the tree below that but the function will start at 1
> b
Hello,
I don't think there's any reason you should use arrays. You can do
everything using tables, and it probably would be easier to use tables
instead. Extracting information from arrays is also more
difficult if you're using something like JDBC or the connectivity
available in PHP. I don't kn
>> For example, if I want to index on a date field but only have the index
>> keep track of the most recent 30 days (and then create a secondary
>> index for all dates) so as to improve performance on more heavily
>> loaded systems.
>>
>> Am I understanding this new terminology correctly? Thank
On Wednesday, November 19, 2003, at 10:26 AM, Abdul Wahab Dahalan wrote:
How do I write a query so that I can get a result as below
[ select only a record/s with same kk and kj but different pngk.
For example here I've 3 records with same kk=01,kj=01 but diff
pngk=a,b,c
and 2 records with same kk
O kyrios Yasir Malik egrapse stis Nov 18, 2003 :
> Hello,
> I don't think there's any reason you should use arrays. You can do
> everything using tables, and it probably would be easier to use tables
> instead. Extracting information from arrays is also more
> difficult if you're using something
O kyrios Randolf Richardson, DevNet SysOp 29 egrapse stis Nov 17, 2003 :
Also intarray contrib package is a good learning place.
> > Can any one give me a link/tutorial for using arrays in databases..I
> > need Queries to access the arrays as well...
>
> A quick search in Google.Com yielde
17 matches
Mail list logo
