Ühel kenal päeval, R, 2006-05-19 kell 11:24, kirjutas Jim C. Nasby: > Something that's always bugged me is how horribly variables are handled > in plpgsql, namely that if you have a variable and a field with the same > name it can be extremely difficult to keep them seperated. Perhaps := vs > = might be a way to keep it clear as to which is which...
I can't see how := helps here. Once you have fields, you are either in SQL-land and always use = or have the fields selected into a type or recors and can use record.field syntax. > Though, a better way would probably just be to provide a built-in > construct for referencing plpgsql variables, such as $. Where is it exactly a problem which can't be solved simply by naming your variables differently from fields? -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com NOTICE: This communication contains privileged or other confidential information. If you have received it in error, please advise the sender by reply email and immediately delete the message and any attachments without copying or disclosing the contents. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org