'[GENERAL] Table Qualifiers in Update Statement'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Table Qualifiers in Update Statement
From:       "Marcel Thibault" <mthibault () novell ! com>
Date:       2005-10-31 17:21:18
Message-ID: 43660C3E.B0DE.0047.0 () novell ! com
[Download RAW message or body]

Hello, 

are table qualifiers acceptable in UPDATE statements in a PostgreSQL DB.


For instance is this not allowed? 

update tablea set tablea.fielda='valuea'; 

Thanks, 

Marcel Thibault
Lead Consulting Engineer
MThibault@novell.com
Phone: (613) 298-3089
Fax: (208) 988-6303

Novell, Inc.
Software for the Open Enterprise
www.novell.com/open







[Attachment #3 (text/html)]

<html>
  <head>
    <style type="text/css">
      <!--
        body { margin-left: 4px; margin-bottom: 1px; font-variant: normal; \
                margin-right: 4px; margin-top: 4px; line-height: normal }
      -->
    </style>
    
  </head>
  <body>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">Hello&#44;
</font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">
</font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">are table qualifiers acceptable in UPDATE \
statements in a PostgreSQL DB. </font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">
</font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">For instance is this not allowed&#63;
</font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">
</font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">update tablea set \
tablea.fielda&#61;&#39;valuea&#39;&#59; </font>    </p>
    <p style="margin-top: 0">
      <font face="Dialog" size="3">
</font>    </p>
    <p style="margin-top: 0">
      Thanks&#44;
    </p>
  <br><p>Marcel&nbsp;Thibault&#13;</p><p>Lead&nbsp;Consulting&nbsp;Engineer&#13;</p><p><a \
href=mailto:MThibault@novell.com&#13;>MThibault@novell.com&#13;</a></p><p>Phone:&nbsp; \
(613)&nbsp;298-3089&#13;</p><p>Fax:&nbsp;(208)&nbsp;988-6303&#13;</p><p>&#13;</p><p>No \
vell,&nbsp;Inc.&#13;</p><p>Software&nbsp;for&nbsp;the&nbsp;Open&nbsp;Enterprise&#13;</p><p><a \
href=http://www.novell.com/open&#13;>www.novell.com/open&#13;</a></p><p>&#13;</p><p>&#13;</p><p>&#13;</p><p></p><br><br></body>
 </html>



[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic