Re: [SQL] Storing properties in a logical way.
On Sun, 05 Sep 2004 19:51:44 +0200, Pierre-Frédéric Caillaud <[EMAIL PROTECTED]> wrote: >> But after looking closely at the list of a possible properties, i found >> out that some of them depend on others. For example, if item is a >> PDF document, it can have an index. But a document can also have an >> index with links. Logically, a properties like 'index with links' >> don't belong to the verification table - they look like a kind of >> a composite field - 'index with links' is not a stand-alone property, >> but it also implies that an item also has an 'index' property. >> On the other hand, it is impossible to decouple 'index' from >> 'with links', because the second part won't have any meaning without >> the first part. > >You mean your properties would be better organized as a tree ? >Or is it even more complicated than that ? I never thought about that possibility - it is an interesting idea, and it solves the logical problem (though there is still a need to ensure that if child property is set, that the user won't be able to also set a parent property - which is probably implementable by using triggers). Though I would prefer, if it is possible, something much simpler, because there are only about 10 properties and 2 'composite' properties - it would probably be an overkill to create a tree for such a small table if a simpler solution exists. Daniel. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] How to rename a constraint/trigger??
Hi to all, I have a database, where in the tables I have around 100 constrains (link to other tables) that don't have a name "" or they have a name like "$1" "$2". Now, I have a module which bases on the same structure, but I get some query errors from a "" constraint. I really don't know exaclty which the constrain generates the error, in that table I have 12 such constrains. Does anyone have a script or it exist a command so that I can rename all the ""constrains in this database? I'm using postgre 7.3.2. Thankx, Andy.
[SQL] When a table was last ANALYZEd
Hello, Is there a way (i.e. a query in pg_catalog) to determine when a table was last ANALYZEd, if at all? -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] Isnumeric function?
Title: Isnumeric function?
How could you determine if a value being inserted into a varchar column is numeric?
I was thinking of using a Regular _expression_ to find this, something like
.. Where content ~* '^[0-9]{1,10}'
There must be an easier way like a isNumeric() function?
Theo
__This email, including attachments, is intended only for the addresseeand may be confidential, privileged and subject to copyright. If youhave received this email in error, please advise the sender and deleteit. If you are not the intended recipient of this email, you must notuse, copy or disclose its content to anyone. You must not copy or communicate to others content that is confidential or subject to copyright, unless you have the consent of the content owner.
Re: [SQL] Isnumeric function?
On Tue, 2004-09-07 at 06:44, Theo Galanakis wrote:
> How could you determine if a value being inserted into a varchar
> column is numeric?
>
> I was thinking of using a Regular expression to find this, something
> like
>
> .. Where content ~* '^[0-9]{1,10}'
~ '^[0-9]+$'
Your version only checks the beginning of the string.
> There must be an easier way like a isNumeric() function?
Not that I know of.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
"For whosoever shall call upon the name of the Lord
shall be saved." Romans 10:13
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
