Function with default value? - Mailing list pgsql-sql

From Daniel CAUNE
Subject Function with default value?
Date
Msg-id 0ITV004G911MRG90@VL-MH-MR002.ip.videotron.ca
Whole thread Raw
Responses Re: Function with default value?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Is it possible to define a function with some default values?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">CREATE OR REPLACE FUNCTION foo(i IN int, j IN int DEFAULT := 1)</span></font><p
class="MsoNormal"style="text-indent:6.0pt"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:10.0pt;font-family:Arial">…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Anyway, I didn’t find such a feature described in the PostgreSQL 8.1 documentation, but
sometimes,that doesn’t mean that the feature doesn’t exist! </span></font><font face="Wingdings" size="2"><span
lang="EN-GB"style="font-size:10.0pt;font-family:Wingdings">J</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Daniel</span></font></div>

pgsql-sql by date:

Previous
From: "Kashmira Patel \(kupatel\)"
Date:
Subject: Re: Question about check constraints
Next
From: Tom Lane
Date:
Subject: Re: Function with default value?