X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 67FF752840 for ; Fri, 5 Aug 2005 05:51:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45173-07 for ; Fri, 5 Aug 2005 08:51:17 +0000 (GMT) Received: from web33411.mail.mud.yahoo.com (web33411.mail.mud.yahoo.com [68.142.206.143]) by svr1.postgresql.org (Postfix) with SMTP id 53FC65280C for ; Fri, 5 Aug 2005 05:51:16 -0300 (ADT) Received: (qmail 98164 invoked by uid 60001); 5 Aug 2005 08:51:18 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=r7Z+h2RCsYSVs3ZCUtRe46NVfmUVXPwbTihKnEXQ5rfC6axom5uLxNQSPIi3eDrBEmjalPg+vJKJA3m01QzRfznlS9hA8HM0YxZH+MZkj4ic/S5hdTzofQpQiGgGu/Jnf/wssK8UPck2Oh8wgFKILGgiZw6kr2Z3p3afF1CMRNQ= ; Message-ID: <20050805085118.98162.qmail@web33411.mail.mud.yahoo.com> Received: from [222.124.70.89] by web33411.mail.mud.yahoo.com via HTTP; Fri, 05 Aug 2005 01:51:18 PDT Date: Fri, 5 Aug 2005 01:51:18 -0700 (PDT) From: Louise Catherine Subject: Make C file for create type To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=4.108 tagged_above=0 required=5 tests=AWL, FORGED_YAHOO_RCVD, FROM_HAS_MIXED_NUMS, FROM_HAS_MIXED_NUMS3 X-Spam-Level: **** X-Archive-Number: 200508/20 X-Sequence-Number: 22248 Hallo, I found a problem making new data type kata,expecially when make the C file ,can anyone help me solve it. This error occur when I'm compiling the C file : /usr/lib/gcc-lib/i586-suse-linux/3.3.1/../../../crt1.o(.text+0x18): In function `_start': ../sysdeps/i386/elf/start.S:98: undefined reference to `main' collect2: ld returned 1 exit status Here it's my code : file3.c ------- #include "postgres.h" typedef struct kata { char kt[30]; } kata; kata *input_kata(char *str); char *output_kata(kata * kata); kata * input_kata(char *str) { char kt[30]; kata *result; if (sscanf(str, "( %s )", &kt) !=1) { printf ("error\n"); return NULL; } result = (kata *) malloc(sizeof(kata)); strcpy(result->kt,kt); return result; } char * output_kata(kata * kata) { char kt[30]; char *result; strcpy(kt,kata->kt); if (strcmp(kt,NULL)) return NULL; result = (char *) malloc(60); sprintf(result, "(%s)", kata->kt); return result; } kata.sql -------- CREATE FUNCTION input_kata(cstring) RETURNS kata AS '_OBJWD_/file3' LANGUAGE C IMMUTABLE STRICT; CREATE FUNCTION output_kata(kata) RETURNS cstring AS '_OBJWD_/file3' LANGUAGE C IMMUTABLE STRICT; CREATE TYPE kata ( INPUT = input_kata, OUTPUT = output_kata ) ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs